SUMPRODUCT IF是否有任何Excel内置功能？

I have a table (a single table) like the picture below. to find the total $ Order 1, I can use SUMPRODUCT(Price,QTY1), SUMPRODUCT(Price,QTY2), however I would like to know the total $ order but devised into A,B,C. The important things I really like to keep structure of the table. I have a table (a single table) like the pictur