Try Sumproduct:-

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

Mike


"yvonneb" wrote:

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:D)

Many thanks
Yvonne