formula to add cells in multiple shts in the same wkbk

[Guest]

Is there a way to add the same cell (ie A1) from multiple worksheets without
manually having to input sum (sheet1A1, sheet2A1, sheet3A1,...)?

 

[Ron de Bruin]

Hi busker

Try this
Put in two dummy sheets(empty sheets) with the name "start" as the first sheet
and one with the name "end" as the last one.


You can use a formula like this then to sum all sheet between start and end
=SUM(start:end!A1)


Another way is to create links to a cell in each sheet and sum them
see http://www.rondebruin.nl/summary.htm

 

[Guest]

If the source sheets are consecutive , use a 3D sum:
=sum('Sheet1A1:Sheet3Z9'!A1) will add up all the A1 cells from Sheet1A1
through Sheet3Z9 (based on the order in which the sheets appear in the
workbook).