If statement count Zero but not empty

[rbylin]

HI

i have this formula

=IF(D9=0;1;0)+IF(E9=0;1;0)+IF(F9=0;1;0)+IF(G9=0;1;0)+IF(H9=0;1;0)+IF(I9=0;1;0)+IF(N9=0;1;0)+IF(M9=0;1;0)+IF(L9=0;1;0)+IF(K9=0;1;0)+IF(J9=0;1;0)


For counting zeros in a document but i dont want excel to count the empty cells as zero

Any suggestions?

 

[Aladin Akyurek]

=COUNTIFS(D9:N9,0)

should do it.

 

[rbylin]

Thank you!!!!!

 

[Aladin Akyurek]

Thank you!!!!!

You are welcome.