Forum Discussion
count.if
Excel Community..., I need your advise in this
I have a 12 numbers serie. (b137:m137)
The three first number are > 0 and the other 9 = 0
When I use =count.if(B137:m137; ¨<>0¨) says there is a problem with the formula.
Where is the problem ?
Thank you for your possible responses
Peter
PETER_VANNI Perhaps multiple causes:
1) The correct function name is COUNTIF, so remove the dot.
2) Where do these double dots surrounding <>0 come from? These should be regular quotation marks. i.e. "<>0"
3) If that doesn't fix it, perhaps you need to use commas in stead of semi-colons to separate the the function arguments.
2 Replies
- Thank you Riny..., it worked. Regards
PETER_VANNI Perhaps multiple causes:
1) The correct function name is COUNTIF, so remove the dot.
2) Where do these double dots surrounding <>0 come from? These should be regular quotation marks. i.e. "<>0"
3) If that doesn't fix it, perhaps you need to use commas in stead of semi-colons to separate the the function arguments.
