| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing up worksheets
How do I sum up totals from different worksheets?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summing up worksheets
=SUM(Sheet1!A1:A10)+SUM(Sheet2!B5:B25)
or maybe =SUM(Sheet1:Sheet3!A1) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Orninn" wrote in message ... How do I sum up totals from different worksheets? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing across several worksheets | Excel Discussion (Misc queries) | |||
| Help finding and summing across worksheets | Excel Worksheet Functions | |||
| summing values for the same cell in 36 different worksheets | Excel Worksheet Functions | |||
| Selecting and summing across worksheets | Excel Discussion (Misc queries) | |||
| SUMMING COLUMNS IN DIFFERENT WORKSHEETS | Excel Discussion (Misc queries) | |||
Linear Mode
