count.if

[PETER_VANNI]

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

[#2 · Accepted solution]

@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. 

[#3]

Thank you Riny..., it worked. Regards