extracting totals from 1 work sheet to another work work sheet
 

I'm trying to extract a number from work sheet 1 and add it to work sheet 2.
eg: In work sheet 2, say line g30,I have a formula enter as "=gh12". I need
to add to the same line to include a total from work sheet 1 "sum(e2:e120)".
Basically, I need line g30 in worksheet 2 to include the totals from
worksheet 1 added to the total in worksheet 2. I need a formula in worksheet
2 line g30 : =gh12 (from worksheet2) + sum(e2:e120) from work sheet1. Any
help would be greatly appreciated. Thanks

extracting totals from 1 work sheet to another work work sheet
 

In cell G30 enter

=GH12 + SUM('Sheet 1'!E2:E120)


Gord Dibben MS Excel MVP

On Sat, 27 Oct 2007 12:40:03 -0700, cj wrote:

I'm trying to extract a number from work sheet 1 and add it to work sheet 2.
eg: In work sheet 2, say line g30,I have a formula enter as "=gh12". I need
to add to the same line to include a total from work sheet 1 "sum(e2:e120)".
Basically, I need line g30 in worksheet 2 to include the totals from
worksheet 1 added to the total in worksheet 2. I need a formula in worksheet
2 line g30 : =gh12 (from worksheet2) + sum(e2:e120) from work sheet1. Any
help would be greatly appreciated. Thanks

extracting totals from 1 work sheet to another work work sheet
 

Work perfect, Thanks for your help!

Cj

"Gord Dibben" wrote:

In cell G30 enter

=GH12 + SUM('Sheet 1'!E2:E120)


Gord Dibben MS Excel MVP

On Sat, 27 Oct 2007 12:40:03 -0700, cj wrote:

I'm trying to extract a number from work sheet 1 and add it to work sheet 2.
eg: In work sheet 2, say line g30,I have a formula enter as "=gh12". I need
to add to the same line to include a total from work sheet 1 "sum(e2:e120)".
Basically, I need line g30 in worksheet 2 to include the totals from
worksheet 1 added to the total in worksheet 2. I need a formula in worksheet
2 line g30 : =gh12 (from worksheet2) + sum(e2:e120) from work sheet1. Any
help would be greatly appreciated. Thanks