multiple sheets

[bobondi]

Hi

Is it possible to have several standard sheets with different values and then one with the total values?

[DonkeyOte]

Yes... if you wish to say sum all A1 cells from Sheet1 to Sheet4 on Sheet5

=SUM(Sheet1:Sheet4!A1)

If your calculations are to be conditional (ie only sum A1 if B1 is "xyz") then things become more complex (and inefficient) quite quickly.