View original (French)

NB if in a discontinuous range

Solved
gamingris Posted messages 9 Status Member -  
gamingris Posted messages 9 Status Member -
Hello,

Can you help me?

I would like to use the COUNTIF function to count the number of cells >0.
But the cells I want to count are not continuous and Excel is giving me a "value error" in the range.

For example: COUNTIF(B33:D33;F33;I33:P33;">0")
In row 33, I have numbers that count attendance for two activities and I would like to count the days when there is no one; this for each of the two activities.
The problem arises from the fact that I do not have a continuous range and I do not know how to do otherwise.
Could this be the issue?
Is there a solution?

Thank you for your help
Configuration: Windows XP Internet Explorer 7.0

2 answers

Answer 1 / 2
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
 
Good evening
Just try this:
=COUNTIF(B33:D33;">0")+COUNTIF(F33;">0")+COUNTIF(I33:P33;">0")
Best regards

--
Let’s ask ourselves if we are the only ones who understand what is being explained?
0
Answer 2 / 2
gamingris Posted messages 9 Status Member
 
Thank you.
I hadn't thought of that.
A bit long to write but it works.

Thank you for your help.
0