View original (French)

NB.SI.ENS Non-empty Cell

Quentin -  
eriiic Posted messages 24581 Registration date   Status Contributeur Last intervention   -
Hello,

I have this:
Potatoes Pears
2 4
3 1
4 5
4

I want to count the number of potatoes if my pears are less than 9 or the cell is empty.
I wrote: =SUMIFS(A:A, IF(B:B<>"", B:B, 9), "<="&9) but it doesn't work, it doesn't count my potatoes row where I have no pears. Why?

Thank you very much

2 réponses

Réponse 1 / 2
Gyrus Posted messages 3360 Status Membre 526
 
Hello,

Try with
=SUMIF(B:B,"<=9",A:A)+SUMIF(B:B,"",A:A)

A+
0