create a formula that determines if “yes†between say C7-C13...

J

Jennifer

I have a formula that multiplies two different cells:
=PRODUCT(B30:B31)

I have another column that determines eligibility (i.e. a “yes†or “noâ€
indicated in each cell).

What I want to do is create a formula that determines if “yes†between say
C7-C13, then multiply the two different cells as described above, otherwise
if blank or “no,†then do not multiply the two cells.

Any help would be greatly appreciated! Thanks in advance!
 
B

Barb Reinhardt

You could try something like this

=PRODUCT(IF(C2:C7="YES",B2:B7))

activate with CTRL SHIFT ENTER
 
B

Barb Reinhardt

You could try something like this

=PRODUCT(IF(C2:C7="YES",B2:B7))

activate with CTRL SHIFT ENTER
 
Top