Adding/updating totals from one worksheet to another

[ilashapiro]

I have created several worksheets within one file. I
have a summary worksheet and multiple detail worksheets.
When I update the detail worksheet I want the totals to
be updated in the summary worksheet. How do I do this?

Thanks for your help.

Ila

 

[Paul B]

Ila, something like this in your detail sheet ='Detail Sheet 1'!A1, and
easy way to do this is to click in your summary sheet where you want the
total from one of your detail sheets and put = then click on the detail
sheet and click on the cell you want and press enter

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

 

[DDM]

Ila, the formulas on your summary sheet must be linked to cells on your
detail sheets. For example:

=Sheet2!A1+Sheet3!B2 will add A1 from Sheet2 and B2 from Sheet3.
=SUM(Sheet2:Sheet6!C1) will sum C1 on Sheets2-6.

You can enter your formulas manually following the syntax above, or you can
create them by pointing and clicking. For the first formula, the point and
click method is this:

1-On your summary sheet, in any cell, type =
2-Switch to another sheet
3-Click the target cell
4-Type +
5-Switch to another sheet
6-Click the target cell
[if necessary, type + and repeat steps 2-3 above; after clicking the last
cell you want to include...]
7-Press Enter.

For the SUM function, the point and click method is this:

1-On your summary sheet, in any cell, type =SUM(
2-Switch to another sheet
3-Click the target cell
4-Hold down Shift and switch to the worksheet containing the last cell you
want to include
5-Press Enter.