MrExcel Publishing
Your One Stop for Excel Tips & Solutions

running totals within subtotals


Posted by Amy Wheeler on September 26, 2001 6:52 AM

Is there any way that you can do running totals withing subtotals automatically.
(i.e. Tim has the following deductions:)

PayEnd Ded Amt Running Total
1/12/01 $15 $15
1/28/01 $15 $30
2/12/01 $20 $50
SUBTOTAL $50


Posted by Russell Hauf on September 26, 2001 7:44 AM

You can just put a formula in your running totals column (let's say it's column C). So in C1 put:

=B1

and in C2 put:

=C1 + B2

Then just drag your formula down.

Hope this helps,

Russell