ProductIf

%3CLINGO-SUB%20id%3D%22lingo-sub-2825446%22%20slang%3D%22en-US%22%3EProductIf%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2825446%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20make%20a%20Product.If%20function%3F%20I%20need%20the%20product%20of%20cells%20in%20column%20B%3AB%20multiplied%20by%20the%20equivalent%20cell%20in%20column%20C%3AC%20IF%20the%20cell%20in%20column%20A%3AA%20has%20a%20certain%20value.%20Example%20attached%2C%20where%20I%20need%20to%20find%20the%20total%20product%2Fsum%20of%20Red%20(should%20be%208).%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22HelleH1004_0-1633672126677.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F316139i03561CE7596BC912%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22HelleH1004_0-1633672126677.png%22%20alt%3D%22HelleH1004_0-1633672126677.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2825446%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2825476%22%20slang%3D%22en-US%22%3ERe%3A%20ProductIf%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2825476%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1179357%22%20target%3D%22_blank%22%3E%40HelleH1004%3C%2FA%3E%26nbsp%3BThat%20could%20be%3A%3C%2FP%3E%3CP%3E%3DSUMPRODUCT(B1%3AB4*C1%3AC4*(A1%3AA4%3D%22Red%22))%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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

@HelleH1004 That could be:

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

Thank you (y) that works. Just what I needed