Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
consolidating data - 3d formula changes from what I type in
when I put in formula in consolidation sheet --- =sum(sheet1:sheet31!b32) and
hit enter -- "#name### shows up in cell and formula bar shows - =SUM(SHEET1:'sheet1:[sheet31]SHEET31'!B32) -- thanks for being there - have a great day |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
consolidating data - 3d formula changes from what I type in
You need to be more accurate when you are posting examples of your problems.
"#name### is not a standard error message in Excel. However, #NAME? is -- is this the error you are receiving? If so, then either Sheet1 or Sheet31 does not exist in your workbook. Based on what showed in the formula bar, it's sheet31 that's the problem. Regards, Fred "dorsecraig" wrote in message ... when I put in formula in consolidation sheet --- =sum(sheet1:sheet31!b32) and hit enter -- "#name### shows up in cell and formula bar shows - =SUM(SHEET1:'sheet1:[sheet31]SHEET31'!B32) -- thanks for being there - have a great day |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidating Data | Excel Worksheet Functions | |||
consolidating data | Excel Discussion (Misc queries) | |||
Consolidating Data | Excel Discussion (Misc queries) | |||
Consolidating Data | Excel Worksheet Functions | |||
Consolidating data?? | Excel Worksheet Functions |