SUMIF using two ranges

[Guest]

I would like to use SUMIF with two IF ranges ie:

If Column A="xxx" and Column B="yyy" then sum column D

Is this possible? I have only every used SUMIF(A:A,"xxx",D)

Many thanks
Yvonne

 

[Bob Phillips]

=SUMPRODUCT(--(A2:A20="xxx"),--(B2:B20="yyy"),D220)

SP cannot work on whole columns, the range has to be explicit.

--
HTH

Bob

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

 

[Guest]

Try Sumproduct:-

=SUMPRODUCT((A1:A100="xxx")*(B1:B100="yyy")*(D1100))

Mike

 

[Guest]

Thanks Bob, got it using your suggestion. Much appreciated.