software

I have eight worksheets in a workbook. The worksheets contains columns of
numbers with a total at the bottom of each column. Is there a way I can add
another worksheet that will add all of the totals of the other eight
worksheets? When the total of any of the eight worksheets change, will the
total change in the new worksheet? I am new to Excel and will appreciate
any help you can give me.
Starlin
The most efficient way would be to put the total in the same cell on each
worksheet and use
=sum(firstsheet:lastsheet!thatcell)

--
Don Guillett
SalesAid Software

quot;Starlin Dotsonquot; gt; wrote in message
...
gt;I have eight worksheets in a workbook. The worksheets contains columns of
gt;numbers with a total at the bottom of each column. Is there a way I can
gt;add another worksheet that will add all of the totals of the other eight
gt;worksheets? When the total of any of the eight worksheets change, will the
gt;total change in the new worksheet? I am new to Excel and will appreciate
gt;any help you can give me.
gt; Starlin
gt;
Hi Starlin

Yes.

Add your new worksheet.

In the desired cell input:

=SUM(Sheet1!totalcell,Sheet2!totalcell,...Sheet8!t otalcell)

where totalcell is the address of the total on each worksheet. Your
Grand Total will change when any cell on the other eight is updated.

Regards

SteveThanks for the help. I'll try it out as soon as I get home.
Starlingt; wrote in message ups.com...
gt; Hi Starlin
gt;
gt; Yes.
gt;
gt; Add your new worksheet.
gt;
gt; In the desired cell input:
gt;
gt; =SUM(Sheet1!totalcell,Sheet2!totalcell,...Sheet8!t otalcell)
gt;
gt; where totalcell is the address of the total on each worksheet. Your
gt; Grand Total will change when any cell on the other eight is updated.
gt;
gt; Regards
gt;
gt; Steve
gt;