Forum Discussion
Solved
ProductIf
How do I make a Product.If function? I need the product of cells in column B:B multiplied by the equivalent cell in column C:C IF the cell in column A:A has a certain value. Example attached, where I need to find the total product/sum of Red (should be 8).
HelleH1004 That could be:
=SUMPRODUCT(B1:B4*C1:C4*(A1:A4="Red"))
2 Replies
HelleH1004 That could be:
=SUMPRODUCT(B1:B4*C1:C4*(A1:A4="Red"))
- Thank you (y) that works. Just what I needed 🙂
