Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Working with 3-D functions across worksheelts
I constructed a set of XL2000 worksheets to record my household utility
bills. They're named Power, Gas, Water, Sewage, and Garbage Pickup (GP). Recently, I added another worksheet named Summary, and inserted the function=SUM(Power:GP!B4) into the corresponding cell beginning. It worked beautifully. However, when I tried to apply the same function to an older (but still XL2000) set of worksheets, it returns NAME? Any ideas of why this function worked in one set and failed in the other? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel FUNCTIONS stop working | Excel Worksheet Functions | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
Changing the range of several averaging functions | Excel Discussion (Misc queries) | |||
Are there functions that perform robust statistics in Excel? | Excel Worksheet Functions | |||
Application.Volatile not working as expected | Excel Discussion (Misc queries) |