Hi,

Is there a short cut to adding up lots of different formulas from different
worksheets?

e.g. "='sheet 1'!F495+'sheet 2'!F495:H495+'sheet 3'!F495:H495+'sheet
4'!F495:H495+'sheet 5'!F495+'sheet 6'!F495

Athough i can use the auto fill for some cells the each worksheet has many
hundreds of cells i need to add up in a 'totals' sheeet.......?