Nov 25 2020 01:56 PM - edited Nov 30 2020 08:52 AM
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 tried several variants, to close and reopen the program, but nothing works. Any idea how to solve this problem?
Many thanks
C.
Nov 25 2020 02:39 PM
If you use a point as decimal separator, you should use comma to separate the arguments of a function:
=COUNTIF(F4:F9,"oui")
Nov 26 2020 12:38 PM
Nov 30 2020 08:50 AM
@Jihad Al-Jarady& @Hans Vogelaar
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