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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
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 |