Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Problem with DSUM (Excel XP)
The formula causing me fits is "=DSUM(Grants,Grants!$E$10,C74:D75)*12"
(without the quotes); it's from a budget worksheet I'm adapting for our org's use. I keep getting a "#VALUE" error. When I simplify it down to retrieving a single value from the worksheet, it does fine. But a DSUM causes the error every time. I've used the forumla checker but it runs out to everything in parentheses and then gives the error. I verified in Insert Names Define that the cell range is the worksheet I need and includes just the cells I need - to include the Totals row at the bottom and the column headers at the top (single row). I don't know how to further "dissect" the DSUM to find the specific problem. Maybe I should delete the name and then re-create it ...... ? Any ideas? -- Mike Webb Platte River Whooping Crane Maintenance Trust, Inc. a 501 (c)(3) conservation non-profit organization |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Problem with DSUM (Excel XP)
I deleted the Name and then re-created it. Now the DSUM works. Must have
been a "gremlin" in the file. "Mike Webb" wrote in message ... The formula causing me fits is "=DSUM(Grants,Grants!$E$10,C74:D75)*12" (without the quotes); it's from a budget worksheet I'm adapting for our org's use. I keep getting a "#VALUE" error. When I simplify it down to retrieving a single value from the worksheet, it does fine. But a DSUM causes the error every time. I've used the forumla checker but it runs out to everything in parentheses and then gives the error. I verified in Insert Names Define that the cell range is the worksheet I need and includes just the cells I need - to include the Totals row at the bottom and the column headers at the top (single row). I don't know how to further "dissect" the DSUM to find the specific problem. Maybe I should delete the name and then re-create it ..... ? Any ideas? -- Mike Webb Platte River Whooping Crane Maintenance Trust, Inc. a 501 (c)(3) conservation non-profit organization |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Problem with criteria for DSUM (Excel XP) | New Users to Excel | |||
Excel 2003 code, problem in Excel 97 | Excel Discussion (Misc queries) | |||
Excel 2000 problem copying drawingobjects between sheets | Excel Discussion (Misc queries) | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) |