dynamic criteria

  • Thread starter Thread starter Drew
  • Start date Start date
D

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,
 
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
 
Back
Top