Totalling Values From The Same Cell In 12 Worksheets Onto New Shee

[Guest]

I have a 'Wages' workbook in which I have 12 sheets; one for each employee. I
changed the tab names to the names of each employee. I want to total the
'Gross Wage' which, in week 1, is in cell G9 on each sheet, and put the
answer onto a new sheet. So that's the total of 12 different G9's.
I started with: ='Sarah Deering'!G9 on the new sheet and that
worked. But I need a formula for all 12. I hope the formula doesn't require
me to type in all 12 names. I want the answer to appear in only one cell in
the new sheet, as a total.
Any ideas? Should the new sheet be in a new workbook?

Thanks. - Gatsby. (Not The Great)

 

[Guest]

It's Me Again.
I sent the above post to 'Set Up' as well (by mistake), and received a
really quick answer from Dave Peterson for which I am truly grateful. So
please ignore above question.
Thanks.
Gatsby (Not The Great)

 

[Dave Peterson]

Check your other post.

I have a 'Wages' workbook in which I have 12 sheets; one for each employee. I
changed the tab names to the names of each employee. I want to total the
'Gross Wage' which, in week 1, is in cell G9 on each sheet, and put the
answer onto a new sheet. So that's the total of 12 different G9's.
I started with: ='Sarah Deering'!G9 on the new sheet and that
worked. But I need a formula for all 12. I hope the formula doesn't require
me to type in all 12 names. I want the answer to appear in only one cell in
the new sheet, as a total.
Any ideas? Should the new sheet be in a new workbook?

Thanks. - Gatsby. (Not The Great)

 

[T. Valko]

I hope the formula doesn't require me to type in all 12 names.

That's one way to do it. Here's another way:

Insert a blank worksheet before employee1 sheet and insert another blank
sheet after employee12 sheet. Name the first inserted sheet Start and name
the last inserted sheet End. Sort of like having "bookends". Then use this
formula:

=SUM(Start:End!G9)

Any sheets between Start and End (inclusive) will be included in the
calculation.

Biff

 

[Dave Peterson]

It's very nice that you posted a reply here.

It's Me Again.
I sent the above post to 'Set Up' as well (by mistake), and received a
really quick answer from Dave Peterson for which I am truly grateful. So
please ignore above question.
Thanks.
Gatsby (Not The Great)