SOLVED

ProductIf

Copper Contributor

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_0-1633672126677.png

 

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@HelleH1004 That could be:

=SUMPRODUCT(B1:B4*C1:C4*(A1:A4="Red"))

Thank you (y) that works. Just what I needed :)
1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@HelleH1004 That could be:

=SUMPRODUCT(B1:B4*C1:C4*(A1:A4="Red"))

View solution in original post