Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
DSUM function
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
DSUM function
Sorry but its not helping much. I am not sure what else I can show or tell
you that would help to figure out. Thanks anyways. -- Too old to be in college "Peo Sjoblom" wrote: 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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
DSUM function
I do my best to stay away from =dsum() (and all the d-functions!).
But lots of times, they can be replaced with =sumif(), =sumifs() (xl2007 only), =sumproduct() or an array formula =sum(). You think your instructor would be willing to accept one of these? Kimmer wrote: 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 -- Dave Peterson |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
DSUM function
I am not sure. because the only example in book is mixed in with =DCOUNT,
=DSUM, and =DAVERAGE. This is an online class and the instructor has been of no help what so ever. Doesnt answer our classes e-mails when we have questions. I am trying to just get through this last assignment and hopefully I can take another excel class somewhere else with more instruction. I dont work with this every day so it is hard to keep the knowledge. I have another post on here with more details and I have even changed the formula. to =DSUM('Employee Data'!A5:I109,"Remaining Vacation Leave",D3:E7 and have gotten the answer 698. Which is wrong. It should be 456. the other post has an example of my two worksheets. thank you. -- Too old to be in college "Dave Peterson" wrote: I do my best to stay away from =dsum() (and all the d-functions!). But lots of times, they can be replaced with =sumif(), =sumifs() (xl2007 only), =sumproduct() or an array formula =sum(). You think your instructor would be willing to accept one of these? Kimmer wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |