Adding multiple worksheets

T

Tee

My company uses excel to budget our labor cost. I want to have the same cell
in multiple sheets (Sheet 1 J4, Sheet 2 J4, through Sheet 12 J4) to add
together in Sheet 12 J4. What are the steps that I need to take in order
for the cells to add?
 
K

Kristin Broggi

In cell J4 on sheet 12 type =sum(
Click on Sheet 1
Click in cell J4 (on sheet1)
While hold the shift key on the keyboard click on sheet11 (don't click any
cell)
Let go of shift
Type )
Press enter.

This will enter the following formula into your spreadsheet
=SUM(Sheet1:Sheet11!J4)

You can also type the formula directly.
 
G

Gord Dibben

Tee

=SUM(Sheet1:Sheet12!J4) entered on Sheet12

Even better is to insert a new dummy sheet at left and a new dummy sheet at
right-end of other sheets.

Name them Start and End

Formula =SUM(Start:End!J4)

Any new sheets can be inserted between these two dummy sheets.

Now it doesn't matter what the intervening sheets are named.


Gord Dibben MS Excel MVP




My company uses excel to budget our labor cost. I want to have the same cell
in multiple sheets (Sheet 1 J4, Sheet 2 J4, through Sheet 12 J4) to add
together in Sheet 12 J4. What are the steps that I need to take in order
for the cells to add?
Click to expand...

Gord Dibben MS Excel MVP
 
Top