Double Sumif

[doowop5000]

I want a double sumif that works as follows:

If Column A = “X” and column B = “Y”, then it will sum the numbers in column C

So basically it will only sum the numbers that have “X” and “Y” in their respective row.

Any help hugely appreciated.

[daddylonglegs]

Try using SUMPRODUCT, you can't use whole columns so try something like

=SUMPRODUCT((A1:A100="x")*(B1:B100="y"),C1:C100)

If you have Excel 2007 you can use SUMIFS.....