My countif function doesn't work at all. I have version 14.2.5 for mac (OS X) and have updated it completely but still it doesn't work. If I try to write the same formula in windows excel, then it works just fine, so it isn't the formula that has an error.

I was using the following simple example:
Data Data
apples 32
oranges 54
peaches 75
apples 86

=COUNTIF(A2:A5,"apples")

But no matter what, I always get: "The formula you typed contains an error"
on all the formula.

Do anyone know what to do?

If you want to count how many times "apples" pops out on the list, you have to use this formula:

=countif(A2:A5, "apples")

There you'll be able to know how many apples there are, but if you want to know the total of the 2 numbers associated with "apples", we have"

=SUMIF(A2:B5,"apple",B2:B5)

There, you will find that there are 118 apples. By the way, I learned this from this website. You can check this out to learn more about sumif: https://www.efinancialmodels.com/kno...tion-in-excel/


Hope this helps