Is there any Excel bulit-in function for SUMPRODUCT IF?
excel
Solution
=SUMPRODUCT(Price*QTY1*(Category="A"))
should do the job, with Category being the name of your "Product Category" column (that containing the letters "A", "B", "C").
Problem
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. Is there any function like SUMPRODUCTIF. If not, is there anyway to make achieve what I would like to achieve? I could make another column and do the QTY*Price to do the SUMIF. However, it adds extra columns