| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i sum the same cell in numerous sheets behind a main
i am preparing a master worksheet to roll up numerous jobs. i want to add
all cells in the same position behind the master sheet. is there a sum fourmula to accomplish this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i sum the same cell in numerous sheets behind a main
Hi,
If the totals are in the same position use =SUM(Sheet1:Sheet3!A1) Sheet1 is the first sheet in your workbook, Sheet3 is the last one, A1 is the cell you want to summarize Change the above to fit your needs. you can do it going to the cell where you want to summarize and enter =sum( then click in the first sheet you want to summarize, press the shift key, hold it and click on the last sheet, then choose the cell to summarize and enter ) "njparamedic" wrote: i am preparing a master worksheet to roll up numerous jobs. i want to add all cells in the same position behind the master sheet. is there a sum fourmula to accomplish this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i sum the same cell in numerous sheets behind a main
=SUM(FirstSheet:LastSheet!A1)
On 14 Maj, 15:13, njparamedic wrote: i am preparing a master worksheet to roll up numerous jobs. *i want to add all cells in the same position behind the master sheet. *is there a sum fourmula to accomplish this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 12 Sheets - Submit to One Main Spreadsheet | Excel Discussion (Misc queries) | |||
| return same cell value from numerous sheets | Excel Worksheet Functions | |||
| how to lookup in numerous different sheets | Excel Discussion (Misc queries) | |||
| Comparing numerous sheets | Excel Discussion (Misc queries) | |||
| Macro to link Sheets to main workbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
