Hi, I have a worksheet with about 1000 rows and 43 columns.
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!