dynamic criteria

[Drew]

I have a list of number and I want to use the Countif
function to count every time there are 1 or more 0 values
in the list but not all the 0 values
example
10
9
34
0
0
34
453
0
0
0
1
2
0


My function would return 3,

 

[Frank Kabel]

Hi
if your data is in A1:A100 try
=SUMPRODUCT((A1:A99<>0)*(A2:A100=0))+(A1=0)

Note the different starting rows for both ranges