-
Product if...
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....
-
Code:
=PRODUCT((A1:A6)^(--(B1:B6="yes")))
Enter as an array formula
-
thank you!
can you explain this formula to me? what does the "--" mean?
-
1 Attachment(s)
See example
You don't really need --; force of habit!
Code:
=PRODUCT((A1:A6)^(B1:B6="yes"))
-
very cool! learned a lot from that example. thank you!