Hi Everyone,

I'm trying to multiply values in column B if the values in column A meet a certain criteria. Example:
Column A: discount type
Column B: discount value

Column A Column B
Rebate 2%
Rebate 1.5%
Discount 3%
Discount 2%
Rebate 5%

Ideally, it should multiply 2%*1.5%*5%.

What's the easiest way to do this? I've only been seeing sumproducts but it doesn't really solve for my purpose.

Thank you very much!