"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