sumproduct issues

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.

No luck, but thanks for trying. In this case, I'm unable to enter the single quotes and have them save/stay. This may be an issue with how SAP data downloads - slightly different formats, numbers = text number, etc. I have managed to make it work in aonther case, but that was working with numerical criteria (codes) and I changed them to number format.

#NA is the result

Yes - If I delete those, then it appear to work. Thanks You very much!