M
Mike Webb
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,'Capital
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?
===============
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,'Capital
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?