Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check Activesheet for chart sheet or work sheet | Charts and Charting in Excel | |||
GETTING SELECTED DATA FROM A WORK SHEET TO OTHER WORK SHEET | Excel Discussion (Misc queries) | |||
Populating work sheet combox with another work sheet values | Excel Discussion (Misc queries) | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions |