Sum same cell from all sheets

[Guest]

I remember seeing this somewhere but can't find it.

How do I sum the same cell in all sheets without clicking on every sheet?

Thanks!

 

[Guest]

Use this formula:

=SUM('First Sheet:Last Sheet'!A1)

Substitute First Sheet and Last Sheet with your actual sheet names.

One trick to use is to insert two new worksheets and name them BEGIN and
END. Place BEGIN before all other sheets, and END after all other sheets.
You can then hide these new worksheets. That way, you can use the formula:

=SUM(BEGIN:END!A1)

Then if you ever need to add/remove worksheets, you won't need to worry
about changing your formula.

HTH,
Elkar

 

[Peo Sjoblom]

Type

=Sum(

Click first sheet, hold down shift and click the last sheet, click the cell
and press enter will give something like

=SUM(Sheet1:Sheet10!E1)

but with your sheet names of course


--


Regards,


Peo Sjoblom