new to excel

  • Thread starter Thread starter adbolak
  • Start date Start date
A

adbolak

I need a 31 day workbook with the 32 worksheet as a monthly. I need to add
totals for all 31 on the 32 sheet for the monthly totals. I hope this makes
sense.
 
Assuming the 31 sheets have their totals in same cell.

In Sheet32 in a cell enter =SUM(Sheet1:Sheet31!A10)

Where A1 is total cell on each sheet.


Gord Dibben MS Excel MVP
 
Hi Gord

Typo alert
Where A1 is total cell on each sheet.
Click to expand...
to match with your formula, it should be where A10 is the total cell on
each sheet.

Hope all is well with you.
 
Slap forehead and thanks.


Gord

Hi Gord

Typo alert
to match with your formula, it should be where A10 is the total cell on
each sheet.

Hope all is well with you.
Click to expand...
 
Hi Gord and Roger

Or this tip from this page
http://www.rondebruin.nl/linksum.htm


Tip: from Lori in the Public.Excel newsgroup on Nov-3-2006

=SUM('*'!A20)

Where the '*' automatically converts to all sheets other than the activate one.
WARNING: Not working in Excel 2002, it crashes the application.

If your workbook have 6 sheets and you enter this formula in sheet3 the formula looks like this.
=SUM(Sheet1:Sheet2!A20,Sheet4:Sheet6!A20)




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
 
Back
Top