![]() |
#1
|
|||
|
|||
![]()
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. |
|