Forum Discussion
i don't have countif in my excel
Hi , I want to use The Countif function but this error is appear this how I use the function : =countif(B2:B50,100) and I have microssoft office 2016
Thank you for your response,
I tried the change "," with ";" and the response that I got is : #NOM?
I tried the change "," with ";" and the response that I got is : #NOM?
In general you don't need to change your default regional settings. You need to use formulae as they are in your language. If you are not sure and know English formula, you may translate it here Translator • Excel-Translator
It gives for
result
However, you eventually may not use default regional setting. They are here
Win+R
control international
ok
Additional settings
Check List separator here
If Excel language is French but List separator is changed on comma, formula will be
=NB.SI(B2:B50,100)
If Excel language is English but you are on default List separator (semicolon), formula will be
=COUNTIF(B2:B50;100)
- Thank you for your help it worked with "=NB.SI(B2:B50,100)" ,
and for the site https://en.excel-translator.de/AbdelilahBzm , you are welcome