Adding multiple worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tee - 18 Aug 2006 16:33 GMT

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?

Reply to this Message

Kristin Broggi - 18 Aug 2006 16:49 GMT

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.

> 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?

Reply to this Message

Gord Dibben - 19 Aug 2006 00:35 GMT

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?

Gord Dibben MS Excel MVP

Reply to this Message