DSUM

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joseph N. - 18 Oct 2007 06:54 GMT

[Excel 2003]
I have a worksheet that looks something like this:

A B C
Charge Payable Paid
$100.00 Y
$650.25 Y
$ 25.00 N 10/1/2007
$ 85.75 Y

I would like to place a formula in a cell that will return the sum of
all expenses in column A for rows which have a "Y" in column B and no
value in column C.

I think DSUM is the function to use, and I have read several help
pages on it, but no formula I have tried has actually worked. I would
appreciate any help.

Reply to this Message

T. Valko - 18 Oct 2007 07:10 GMT

Try this:

=SUMPRODUCT(A2:A100,--(B2:B100="Y"),--(C2:C100=""))

Signature

Biff
Microsoft Excel MVP

> [Excel 2003]
> I have a worksheet that looks something like this:
[quoted text clipped - 13 lines]
> pages on it, but no formula I have tried has actually worked. I would
> appreciate any help.

Reply to this Message

Bob Phillips - 18 Oct 2007 08:22 GMT

Put Payable in say H1 and Y in H2, and use

=DSUM(A:C,"Charge",H1:H2)

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> [Excel 2003]
> I have a worksheet that looks something like this:
[quoted text clipped - 13 lines]
> pages on it, but no formula I have tried has actually worked. I would
> appreciate any help.

Reply to this Message

Rate this thread: