| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
hi,
2 ways. if already totaled on the different sheets and assuming the totals are in A1... =Sheet1!A1+Sheet2!A1+Sheet3!A1 if not totaled and assuming the columns to total are all column G.... =sum(sheets1!G2:G50)+Sum(Sheet2!G2:G50)+Sum(Sheet3 !G2+G50) Regards FSt1 "ExcelNewby" wrote: How do I use the SUM function to total amounts from one sheet to another within the same document? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I total amounts on various sheets in excel?
Hi,
I tried that for a subtraction sheet1A1-sheet2a1..and it is not working. Basically I have 2 sheets within the same workbook and I want to subtract each cell in sheet 2 from the corresponding cel in sheet1 Thanks Rabab "FSt1" wrote: hi, 2 ways. if already totaled on the different sheets and assuming the totals are in A1... =Sheet1!A1+Sheet2!A1+Sheet3!A1 if not totaled and assuming the columns to total are all column G.... =sum(sheets1!G2:G50)+Sum(Sheet2!G2:G50)+Sum(Sheet3 !G2+G50) Regards FSt1 "ExcelNewby" wrote: How do I use the SUM function to total amounts from one sheet to another within the same document? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I total amounts on various sheets in excel?
Read the suggestion again and don't forget the punctuation.
-- David Biddulph "RABAB ALI" <RABAB wrote in message ... Hi, I tried that for a subtraction sheet1A1-sheet2a1..and it is not working. Basically I have 2 sheets within the same workbook and I want to subtract each cell in sheet 2 from the corresponding cel in sheet1 Thanks Rabab "FSt1" wrote: hi, 2 ways. if already totaled on the different sheets and assuming the totals are in A1... =Sheet1!A1+Sheet2!A1+Sheet3!A1 if not totaled and assuming the columns to total are all column G.... =sum(sheets1!G2:G50)+Sum(Sheet2!G2:G50)+Sum(Sheet3 !G2+G50) Regards FSt1 "ExcelNewby" wrote: How do I use the SUM function to total amounts from one sheet to another within the same document? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add a total to a stacked bar graph in Excel | Charts and Charting in Excel | |||
| excel self total | Excel Discussion (Misc queries) | |||
| How can I merge multiple sheets from different Excel files workbo. | Excel Worksheet Functions | |||
| How do I print all sheets of an Excel workbook from explorer? | Excel Discussion (Misc queries) | |||
| how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
Hybrid Mode
