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.

 

[Simon Lloyd]

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.adbolak, we need a little more information than that, where would the

total row be? would it be different for each sheet? are you looking to
re-use the sheets each month to build the monthly data in sheet 32? if
this is the case you cannot do it with formulae alone.....give us a bit
more information and we will do our best to provide a solution!


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)

 

[Pecoflyer]

Hi,
instead of making things complicated with 32 sheets ( which as you can
see are already causing problems) why not make a simple list ?
List feature

You can designate a contiguous range of cells on your worksheet as a
list (list: A series of rows that contains related data or a series of
rows that you designate to function as a datasheet by using the Create
List command.). When you create a list, data defined by the list can be
manipulated independently of data outside of the list. After you create
a list, you can use list features to quickly sort, filter, total, or
publish the data contained within the list.

You can also use the list feature to compartmentalize sets of related
data by organizing that data using multiple lists on a single worksheet.

It is then very easy to use XL's tolls to create summarys, tables,
etc..

 

[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