This would be a great tool for many situations, but it never seems to work for me. Simple case at hand: I am trying to total some numbers based on 2 criteria - country, and product name. Can the criteria be variables? Here is my formula:

=SUMPRODUCT((SAP_1202_120227!$AO$2:$AO$177=A54)*(SAP_1202_120227!$AN$2:$AN$177=B53)*(SAP_1202_120227!$AH$2:$AH$177))

column AO in my data table should contain the country (cell A54)
column AN should contain the product (cell B53)
column AH is the data that I am trying to total.

Someone can solve this one, and I'll owe you my first born. Then again, I'm pretty ugly.