Help, add subtotals included in one column to get a grand total

[Guest]

exel 07
I am trying to add up subtotals in a column to equal a grand total without
duplicate addition from the sums being in the same column. I have also
highlighted the data I want to add.

 

[Pete_UK]

Are you using SUM( .. ) on different rows to give you the subtotals?
If so, then you should change this to SUBTOTAL(9,..). An easy way is
to highlight the column by clicking on the column identifier then CTRL-
H (Edit|Replace) and in the dialogue box put:

Find What: SUM(
Replace With: SUBTOTAL(9,

(exactly as typed above), then click Replace All.

Then for your Grand Total row you should also use

=SUBTOTAL(9, range)

where range is the for the whole of the column of data, eg A1:A3000.

Hope this helps.

Pete