Subtotals Revisited

T

tx12345

Hi

Let's say i have a column like this:
A __ B
1
1
1
1__magic formula says "4"
empty
empty
empty
1
1
1
1
1__magic formula says "5"


Is there a formula I can place in B to subtotal what is in A? All I
want to do is get the totals for each little group on the way down. I
am trying to get around the Subtotals ... menu command in the Data Menu

Thanks

tx
 
Top