Forum Discussion
Solved
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 ...
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.
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.