View original (French)

NB.SI.ENS Non-empty Cell

Quentin -  
eriiic Posted messages 24581 Registration date   Status Contributor 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 answers

  1.
    Gyrus Posted messages 3360 Status Member 526
     
    Hello,

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

    A+
    0