SUMIF using multiple criteria 1

[HairyHippy]

Hi

I have these two formulae:

=SUMIF(A:A,"abc",C:C)
and
=SUMIF(B:B,"xyz",C:C)

can I combine them so that it sums the rows in column C that both "abc" appears in column A and "xyz" appears in column B?

Thanks in advance

 

[HairyHippy]

I know that it's not:
=sumif(A:B,And("abc","xyz"),C:C)

 

[Lilliabeth]

=SUMPRODUCT((A1:A5000="abc")*(B1:B5000="xyz")*(C1:C5000))