G
galaxytraveler42
My countif function doesn't work at all. I have version 14.2.5 for ma
(OS X) and have updated it completely but still it doesn't work. If
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 a
error"
on all the formula.
Do anyone know what to do
(OS X) and have updated it completely but still it doesn't work. If
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 a
error"
on all the formula.
Do anyone know what to do