extracting totals from 1 work sheet to another work work sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top