Subtotals

[Guest]

I have a sheet that I'm formatting for usage documentation. I have done all the calculations, but need the subtotal cell to continue to add up not decend each time I change the numbers in the cells above?

 

[Dave Peterson]

It sounds like you're changing a value (say from 100 to 10), but want the
subtotal to include both the 10 and the previous 100.

Formulas won't work like this.

Can you insert another row and add your new data there?

 

[Guest]

Why not do a sheet for each item you are documenting the
use on and draw your subtotals from those?

For gas useage, we have a sheet for BIG TANK that lists
each department (Land,Maint,etc) and the amount of gas
used. These are totaled at the bottom and also include
a percentage of the grand total (land used 98.1% of the
big tank, etc..

On a seperate sheet we have the invoice amounts and we do
an average cost per gallon for the month.. the totals
from the tank sheets are imported and multiplied by the
cost per gallon.. giving us (supposedly) the cost of gas
used by each department every month.

Marge

-----Original Message-----
I have a sheet that I'm formatting for usage

documentation. I have done all the calculations, but need
the subtotal cell to continue to add up not decend each
time I change the numbers in the cells above?