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!