Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Multiple Worksheets, same named cell
I have multiple worksheets containing the same named cell (e.g. Month_Total).
On a totals worksheet, I am not able to use =SUM('START,END'!Month_Total) because of the local/global naming. Is there a way around this? (Month_Total will not always be in the same cell on each worksheet). Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Multiple Worksheets, same named cell
It seems to me that you have two options.
1. Name each of your "Monthly Total"s slightly different. OR 2. Do not use the cell range naming. "uncreative" wrote in message ... I have multiple worksheets containing the same named cell (e.g. Month_Total). On a totals worksheet, I am not able to use =SUM('START,END'!Month_Total) because of the local/global naming. Is there a way around this? (Month_Total will not always be in the same cell on each worksheet). Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named Ranges - Multiple Worksheets | Excel Discussion (Misc queries) | |||
how do i add up the same cell from multiple named tab sheets | Excel Discussion (Misc queries) | |||
same named cell in separate worksheets | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
same named range on multiple worksheets? | Excel Discussion (Misc queries) |