formula to add cells in multiple shts in the same wkbk

[busker]

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



--
Regards Ron de Bruin
http://www.rondebruin.nl



"busker" <[email protected]> wrote in message news:[email protected]...
> Is there a way to add the same cell (ie A1) from multiple worksheets without
> manually having to input sum (sheet1A1, sheet2A1, sheet3A1,...)?
>

[bpeltzer]

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).

"busker" wrote:

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