Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using the function DSUM | Excel Discussion (Misc queries) | |||
DSUM function | Excel Worksheet Functions | |||
DSUM - Modifying the function... | Excel Worksheet Functions | |||
Prom with the DSUM function | Excel Worksheet Functions | |||
DSum function | Excel Worksheet Functions |