Count sequential zeros in a column

[ktpalmer]

Hi everyone!

I need help for a formula to subtotal a set of zeros in the column next to it.
e.g. A1,A2,A3 all = 0, and A4 = 1, then in B3 will be the subtotal 3.
Have attached an example of what I need the spreadsheet to look like.

The formula is going into a spreadsheet that has over 8000 cells in a column, representing every 10 seconds of the day.

Is this possible?

Many thanks, Katie.

[teylyn]

Hello Katie,

try this in B2 and copy down

=IF(AND(A2=0,OR(A3<>0,A3="")),COUNTIF($A$2:A2,0)-SUM($C$1:C1),"")

cheers