SOLVED

# count.if

Copper Contributor

# count.if

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 Replies
best response confirmed by HansVogelaar (MVP)
Solution

# Re: count.if

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

# Re: count.if

Thank you Riny..., it worked. Regards
1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
Solution

# Re: count.if

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