Thread: Subtotaling
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Katie Katie is offline
external usenet poster
 
Posts: 130
Default 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