Sum same cell from all sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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
 
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
 
Back
Top