| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of cell on numerous worksheets in a workbook
I have created 13 worksheets. My 13th sheet is my "Totals Sheet". What
formula do i use to add cell "AG13" from sheet1-sheet12? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum of cell on numerous worksheets in a workbook
=SUM('Sheet 1:Sheet12'!G13)
"Johnny D" wrote: I have created 13 worksheets. My 13th sheet is my "Totals Sheet". What formula do i use to add cell "AG13" from sheet1-sheet12? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum of cell on numerous worksheets in a workbook
Hi Johnny
Try this =SUM(Sheet1:Sheet12!AG13) -- Regards Ron de Bruin http://www.rondebruin.nl "Johnny D" wrote in message ... I have created 13 worksheets. My 13th sheet is my "Totals Sheet". What formula do i use to add cell "AG13" from sheet1-sheet12? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum of cell on numerous worksheets in a workbook
When i copy and past this, as soon as i hit "enter", a popup comes up and
says "macros disabled. please close this workbook and reopen with macros enabled....HELP????? "Ron de Bruin" wrote: Hi Johnny Try this =SUM(Sheet1:Sheet12!AG13) -- Regards Ron de Bruin http://www.rondebruin.nl "Johnny D" wrote in message ... I have created 13 worksheets. My 13th sheet is my "Totals Sheet". What formula do i use to add cell "AG13" from sheet1-sheet12? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum of cell on numerous worksheets in a workbook
This is a worksheet function and you copy this in a cell
I reply to your private post with this =SUM('Jan 06:Dec 06'!AJ15) -- Regards Ron de Bruin http://www.rondebruin.nl "Johnny D" wrote in message ... When i copy and past this, as soon as i hit "enter", a popup comes up and says "macros disabled. please close this workbook and reopen with macros enabled....HELP????? "Ron de Bruin" wrote: Hi Johnny Try this =SUM(Sheet1:Sheet12!AG13) -- Regards Ron de Bruin http://www.rondebruin.nl "Johnny D" wrote in message ... I have created 13 worksheets. My 13th sheet is my "Totals Sheet". What formula do i use to add cell "AG13" from sheet1-sheet12? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel should let its worksheets be arranged (tiled) in a workbook | Excel Worksheet Functions | |||
| Adding cell contents in different worksheets | Excel Discussion (Misc queries) | |||
| Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
| How can I Copy cell names from one workbook to another? | Excel Discussion (Misc queries) | |||
| linking cell value in one workbook to a cell in another workbook | Links and Linking in Excel | |||
Linear Mode
