Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
DSUM not pulling the data - why
Using Excel XP.
=============== I'm setting up a budget workbook, and one sheet (5 Year Strategic Plan) has a DSUM in it under a column labeled "2007": =DSUM(Capital,'Capital Projects'!$P$3,$E$39:$F$42)*12+DSUM(Capital,'Capit al Projects'!$P$3,$V$17:$W$23) It shows "zero" as the value pulled, yet when I look at the sheet labeled "Capital Projects", I see 2 values that should have been pulled (just dummy data for now): $1500 on Jan 2007 and $2000 on June 2007. $E$39:$F$42 corresponds to: Capital Timing Land Monthly Buildings Monthly Vehicles Monthly and $V$17:$W$23 corresponds to: Capital Timing Land 2007 Land Is not monthly Buildings 2007 Buildings Is not monthly Vehicles 2007 Vehicles Is not monthly I've done this many times before in this workbook, so Im don't know where I went wrong. Any ideas/comments? -- 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 | |||
Pulling Data off Web - Need Function Help | Excel Worksheet Functions | |||
ranking query | Excel Discussion (Misc queries) | |||
Macro pulling data from 2 worksheets | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel |