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

[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!

 

[Barb Reinhardt]

You could try something like this

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

activate with CTRL SHIFT ENTER

 

[JMB]

try:
=IF(COUNTIF(C7:C13,"yes"), B30*B31, "")

 

[Barb Reinhardt]

You could try something like this

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

activate with CTRL SHIFT ENTER