It is a pretty good explanation in help for the D function, first of all D4
is in place of the the criteria so it means it needs at least 2 cells not
one. Most likeley the table is more than one column in dimension. 17 in your
case is the header of the column you want to sum.

Regards,

Peo Sjoblom


"Kimmer" wrote in message
...
another quetion with my homework.
Use the DSUM function to calculate the total number of vacation days
remaining.
I put in this: =DSUM('Employee Data'!E6:E109,"17",D4)
You do this for days remaining. I get the E6:E109 from the Employee Data
sheet that Is titled Remaining Vacation Leave. I get the D4 from my leave
summary sheet that shows the total days as 612. You do this for 17 day
vac,
12 days of vacation,7 and then 0. I get an error #VALUE Not sure what to
do
or where to go with this.
--
Too old to be in college