adding up multiple sheets

  • Thread starter Thread starter Louis
  • Start date Start date
L

Louis

I have a summary sheet that has the totals. I need to add
the totals in several sheets. I want the total of the
sheets to show up on the summary sheet.

Is there a quicker way of doing this than clicking on each
sheet, then using the + sign, then clicking on the next
sheet etc....?

Thank you

Louis
 
Louis,

You can simply do =SUM(Sheet1:Sheet3!A1)

Manually, you can enter =SUM( in the formula bar, and before you hit Enter,
select a sheet and a cell on that sheet, and then type, then another and so
on until completed, then just type in ) and Enter.
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
hello Louis,

just don't forget Bob's suggestion is still dependendt upon shee
location. eg if the order of your sheets is Sheet1, Sheet3, Sheet2 -
Sheet2 will not be counted in formula
 
-----Original Message-----
hello Louis,

just don't forget Bob's suggestion is still dependendt upon sheet
location. eg if the order of your sheets is Sheet1, Sheet3, Sheet2 --
Sheet2 will not be counted in formula.
Click to expand...
Thank you.....worked like a charm

Louis
 
Back
Top