Hi

Let's say i have a column like this:
A __ B
1
1
1
1__formula says "4"
empty
empty
empty
1
1
1
1
1__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


--
tx12345
------------------------------------------------------------------------
tx12345's Profile: http://www.excelforum.com/member.php...o&userid=24776
View this thread: http://www.excelforum.com/showthread...hreadid=505199