Product if...

[tkaplan]

I know I've done this before....I'm just drawing a blank as to how.....
column A is numbers. Column B is "yes" or "no".
I want to multiply all the values in column A that the corresponding column B is "yes". i know there's a "sumif" function if I wanted to add them together, but I need to multiply.

thanks in advance....

[mdmackillop]

=PRODUCT((A1:A6)^(--(B1:B6="yes")))
Enter as an array formula

[tkaplan]

thank you!
can you explain this formula to me? what does the "--" mean?

[mdmackillop]

See example
You don't really need --; force of habit!

=PRODUCT((A1:A6)^(B1:B6="yes"))

[tkaplan]

very cool! learned a lot from that example. thank you!