Is there a way I can add totals in worksheet?

S

Starlin Dotson

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
 
D

Don Guillett

The most efficient way would be to put the total in the same cell on each
worksheet and use
=sum(firstsheet:lastsheet!thatcell)
 
B

britwiz

Hi Starlin

Yes.

Add your new worksheet.

In the desired cell input:

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

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

Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

totals 4
Referrence a total in a cell on another worksheet 4
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel workbooks 3
moving totals 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Using VBA to copy data into another worksheet ??? 2
Spreadsheet summary automatically referrences totals of worksheets 2

Top