Forum Discussion
SOLVED - Error message instead the calculation of an correct COUNTIF formula.
Hi everybody, Excel is supposed to be logical, but I can't recognize it. My COUNTIF formula is exact and yet it refuses to compute it by sending me an error message (see attached picture). I trie...
If you use a point as decimal separator, you should use comma to separate the arguments of a function:
=COUNTIF(F4:F9,"oui")
it is a common problem, using the wrong arguments separator
And common problem when you juggle between computers configured with different languages... Never paid attention to this difference in separator before. Thanks for your help!
Best!
C
