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