Forum Discussion
AbdelilahBzm
Jan 18, 2022Copper Contributor
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
PeterBartholomew1
Jan 18, 2022Silver Contributor
Your formula works fine on my computer but, then, I have an English language version of Excel with comma as the parameter separator..
= NB.SI(B2:B50;100)
If you are using a French language version wouldn't something like the above be more appropriate?
AbdelilahBzm
Jan 19, 2022Copper Contributor
Your formula is working thank you