I have a problem with functions such as maxif and sumif. When I try to use any of them in my project the console returns 'Function not found: sumif/maxif; Did you mean sum/max?'

It is odd, because function countif works perfectly fine, and both of maxif and sumif are described in the BigQuery documentation, so I'm kind of worried what to do with them in order to run the code properly.

Beneath is a part of my code, any suggestions would be most welcome:

```
SELECT
  DISTINCT *,
  COUNTIF(status ='completed') OVER (PARTITION BY id ORDER BY created_at) cpp,  --this works
  sumif(value,status='completed') OVER (PARTITION BY id ORDER BY created_at) spp, -- this doesn't
  maxif(created_at, status = 'completed') OVER (PARTITION BY id ORDER BY created_at DESC) lastpp,
FROM
  `production.payment_transactions` 

```