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?