SOLVED - Error message instead the calculation of an correct COUNTIF formula.

%3CLINGO-SUB%20id%3D%22lingo-sub-1932481%22%20slang%3D%22en-US%22%3EError%20message%20instead%20the%20calculation%20of%20an%20correct%20COUNTIF%20formula.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1932481%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everybody%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20is%20supposed%20to%20be%20logical%2C%20but%20I%20can't%20recognize%20it.%20My%20COUNTIF%20formula%20is%20exact%20and%20yet%20it%20refuses%20to%20compute%20it%20by%20sending%20me%20an%20error%20message%20(see%20attached%20picture).%20I%20tried%20several%20variants%2C%20to%20close%20and%20reopen%20the%20program%2C%20but%20nothing%20works.%20Any%20idea%20how%20to%20solve%20this%20problem%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3CP%3EC.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1932481%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1932532%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20message%20instead%20the%20calculation%20of%20an%20correct%20COUNTIF%20formula.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1932532%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F534387%22%20target%3D%22_blank%22%3E%40CalasidA%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20use%20a%20point%20as%20decimal%20separator%2C%20you%20should%20use%20comma%20to%20separate%20the%20arguments%20of%20a%20function%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DCOUNTIF(F4%3AF9%2C%22oui%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1934872%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20message%20instead%20the%20calculation%20of%20an%20correct%20COUNTIF%20formula.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1934872%22%20slang%3D%22en-US%22%3Eit%20is%20a%20common%20problem%2C%20using%20the%20wrong%20arguments%20separator%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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.

3 Replies

@CalasidA 

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

@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