new to excel

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

 

[Gord Dibben]

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

 

[Roger Govier]

Hi Gord

Typo alert

Where A1 is total cell on each sheet.

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

Hope all is well with you.

 

[Gord Dibben]

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.

 

[Ron de Bruin]

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