Try SUMIF()
=SUMIF(D2:D20,"x",B2:B20)


Or try this array formula (your formula modified)
=SUM(--(B2:B20)*(D2:D20="x"))


If this post helps click Yes
---------------
Jacob Skaria


"Danny Boy" wrote:

I must have a brain cramp because I can't get the formula below to work. In
Column A I have items to buy, in Column B I have dollar amounts associated
with each item, and in column D I have placed an "x" next to items as I
purchase them. The formula below is in cell F2, and is designed to add all
purchases, when an "x" is placed in column D. If there is a purchase amount
in column B, without an "x" in Column D, than the formula shouldn't add the
purchase amounts. What I have below (when entered as an array isn't working).
Any help would be appreciated.

Thanks, Dan

=SUM(B2:B20)*(D2:D20="x")