Sumif with multiple criteria
Sumif with multiple criteria
(OP)
Hi All,
Wondering if you could give me a hand with this. I need a formula that will:
Sumif column D if the contents of column C are in column B and have an "x" next to them in column A.
I've picked this apart but can't find the right combination of functions to make it happen!
A B C D
x a d 8.00
x b b 3.31
x c e 6.5
. d
x e
Thanks, Doug





RE: Sumif with multiple criteria
TTFN

FAQ731-376: Eng-Tips.com Forum Policies
Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers
Of course I can. I can do anything. I can do absolutely anything. I'm an expert!
RE: Sumif with multiple criteria
I should have done this before. I've included a picture that I hope is a better representation of my dilemma.
Thanks again, Doug
RE: Sumif with multiple criteria
Link
RE: Sumif with multiple criteria
TTFN

FAQ731-376: Eng-Tips.com Forum Policies
Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers
Of course I can. I can do anything. I can do absolutely anything. I'm an expert!
RE: Sumif with multiple criteria
Does this formula give the correct answer
=SUMPRODUCT((B1:B5=C1:C5)*(A1:A5="x")*D1:D5)
change ranges as required, but they must reference the same row numbers
----------------------------------
Hope this helps.
----------------------------------
maybe only a drafter
but the best user at this company!
RE: Sumif with multiple criteria