DSUM function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kimmer - 19 Apr 2008 03:12 GMT

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.

Signature

Too old to be in college

Reply to this Message

Peo Sjoblom - 19 Apr 2008 03:50 GMT

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

> another quetion with my homework.
> Use the DSUM function to calculate the total number of vacation days
[quoted text clipped - 7 lines]
> do
> or where to go with this.

Reply to this Message

Kimmer - 19 Apr 2008 03:57 GMT

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.

Signature

Too old to be in college

> 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
[quoted text clipped - 16 lines]
> > do
> > or where to go with this.

Reply to this Message

Dave Peterson - 19 Apr 2008 21:02 GMT

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?

> another quetion with my homework.
> Use the DSUM function to calculate the total number of vacation days
[quoted text clipped - 7 lines]
> --
> Too old to be in college

Signature

Dave Peterson

Reply to this Message

Kimmer - 19 Apr 2008 21:14 GMT

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.

Signature

Too old to be in college

> I do my best to stay away from =dsum() (and all the d-functions!).
>
[quoted text clipped - 14 lines]
> > --
> > Too old to be in college

Reply to this Message

Rate this thread: