extracting totals from 1 work sheet to another work work sheet

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing up various Worksheets to one Summary sheet using variables 1
Lock location of sheet within a spreadsheet 4
Summary Sheet Totals 7
how do i bring numbers from one work sheet to another 1
Totals from sheet to sheet 1
Formula needed for adding every nth column on another sheet 6
adding columns on different worksheets 3
auto update to multiple worksheets 2

Top