DSUM function

K

Kimmer

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.
 
P

Peo Sjoblom

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
 
K

Kimmer

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.
 
D

Dave Peterson

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?
 
K

Kimmer

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top