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
