| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
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? |
| 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) | |||
Threaded Mode
