**Quick Answer:** Add a filter to your formula and then add `SUM()`

, `COUNT()`

, or `AVERAGE()`

to the end of your formula

If you’ve tried using `SUMIF`

or `COUNTIF`

in Coda, you may have run into a few snags. I hear you, I was frustrated too when I couldn’t figure out why a basic `SUMIF`

formula wouldn’t work in Coda. First off, you can only SUM or COUNT if the predicate is a number (not text) and you have to use the tricky `CurrentValue`

to get the number. I know, a little crazy. **Excel seems so much easier right?** Look how simple this is:

It’s pretty similar with `COUNTIF`

and `AVERAGEIF`

as you know. So how about Coda? **It’s different, yes, but simpler in it’s own way**. So to get the `SUMIF`

to work the same way as in Excel (in this case summing all the “Counts” where the “Fruit”=“Watermelon”):

If this was a contest to write the shortest formula to get the sum, Excel would totally win. But in Coda, there aren’t any fuzzy references to D12:D20 or other cell ranges, you use **words** that describe the data instead of **cell references**. The biggest difference with this formula is that you **chain** the `SUM`

function to the data.