Is there a bulit-in Excel function for SUMPRODUCT IF?

Question

I have a table (one table), as in the picture below. to find the generic $ Order 1, I can use SUMPRODUCT (Price, QTY1), SUMPRODUCT (Price, QTY2), however I would like to know the generic $ order, but it was developed in A, B, C. Important things that I really like keep the table structure.

Is there any function like SUMPRODUCTIF. If not, is there a way to achieve what I would like to achieve?

I could make another column and do QTY * Price to make SUMIF. However, it adds extra columns

Answer 1

=SUMPRODUCT(Price*QTY1*(Category="A")) 

should do the job, and Category is the name of your Product Category column (containing the letters "A", "B", "C").