Subtotaling Sequential 0's
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.
|