K

#### Karin

In one column (A) are contract numbers that I can subtotal on, which is what

I want to do. The problem is that not all of the subtotals should be "sum",

some need to be a formula based on the sum of other columns.

Do you have any suggestions for how I can consolidate this sheet, get the

proper subtotal function, and be able to update it? A pivot table will not

let me use a formula, subtotaling comes close, but it won't keep the formula

if I retotal.

FYI: I'm familiar with vlookups and other formulas.

TIA!