DSUM

[Joseph N.]

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

 

[T. Valko]

Try this:

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

 

[Bob Phillips]

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

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

--
HTH

Bob

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