Hi all,

Could somebody help me create a formula to sumif across two columns. Attached is an example. Columns F&G are columns A&B with removed duplicates.

I am looking for the total values of C against each combination of A&B. In Red is the answer that I am trying to get to.


What formula can i put in column H to produce this result?

Thanks

Excel 2003 or earlier use: =SUMPRODUCT((A$1:A$11=F1)*(B$1:B$11=G1),C$1:C$11)
Excel 2007 or later use: =SUMIFS(C$1:C$11,A$1:A$11,F1,B$1:B$11,G1)

Enter in H1 and copy down.