Thread: DSUM function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Kimmer Kimmer is offline
external usenet poster
 
Posts: 25
Default DSUM function

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