Subtotaling
I need a formula to subtotal each set of 1's in a column, without subtotaling
other numbers in the column.
example shown below.
1 )
1 ) subtotal = 2
2 ]
5 ]
6 ]
7 ] no subtotal
1 )
1 )
1 )
1 )
1 )
1 ) subtotal = 6
5 ]
6 ]
7 ]
6 ]
5 ] no subtotal
1 ) subtotal = 1
|