cnfidelis

asked on

# How to i replicate a ProductIF function where i multiply values based on criteria vs adding them?

Is there an Excel ProductIF function?

I basically want to reproduce a SumIf function whereby a value in a column corresponds to a value in a range to

I'm interested in dynamic what-if values in Column D.

thanks!

cn

ProductIF.PNG

I basically want to reproduce a SumIf function whereby a value in a column corresponds to a value in a range to

__against another column across from it containing a value .. in this case, i want to lookup a value in .. i've attached a screen shot of a simplified table which produces my answer in Column D.. BUT obviously, i want to change the value of range B11:B15 and have it refer to the matching % values in range C2:C8.__**multiply**I'm interested in dynamic what-if values in Column D.

thanks!

cn

ProductIF.PNG

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**
ASKER

thanks a bunch!

cn