The formula, in two columns, needs to be: (2nd column is similar, diff
references)
=Reconcilliation!$D$2*(G1453/Reconcilliation!$D$3)
In two other columns, the formula is: =IF(AH409AC409,AH409-AC409,0)
What I've done is subtotal and then copy the formulas in manually. I don't
know of a better way. There are 550 subtotals, but I just copy the formula
straight down, I don't have to put it in individually. It doesn't stick if I
recalculate.


"TomPl" wrote:

"some need to be a formula based on the sum of other columns" is pretty vague
making it dificult to come up with a specific solution. One thing you might
try is to use sumif or sumproduct to get your totals. I would do this on a
seperate worksheet because it is better if you do not mix formulas in your
data.

Tom