Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I correct a range 'reference'?
Using Excel XP.
===================== I've had a frustrating time with DSUM on a workbook I'm building from someone else's model - I keep getting #VALUE! errors. After lots of looking "underneath the hood" I think I see the problem, but don't know how to fix it. One of the formulas is: =DSUM(Revenue,'Revenue Projects'!$D$3,B1:B3) The problem comes up with "Revenue". When I use the Evaluate Formula tool, it italicizes "Revenue", and when I click on Evaluate, I see 'Revenue Projects'$A$1:$J$14 in it's place - italicized. I click Evaluate again and get the #VALUE! error. When I took a hard lok at this, I think the problem is that the worksheet ('Revenue Projects') refered to by the database (Revenue), has the WRONG range of cells. It should be $A$1:$O$19. How do I change this "inside" Excel? (This is the only thing I can find that might be causing this error.) -- Mike Webb Platte River Whooping Crane Maintenance Trust, Inc. a 501 (c)(3) conservation non-profit organization |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference Data Range based on cell contents | Charts and Charting in Excel | |||
Reference range of cells and perform subtraction or nothing depending on contents | Excel Worksheet Functions | |||
Using a NAME as a reference in another range | Excel Discussion (Misc queries) | |||
Using a formula to create named range reference | Excel Worksheet Functions | |||
How to dynamically reference a dynamic named range | Excel Worksheet Functions |