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.

Attached Files

example.xls (14.5 KB, 14 views)