I have two formulas that I know to work.

The first looks at a cell and returns to check for two values then
conditionally does one of two things based on the values.

=(OR(H151="business",H151="personal")*(IF(H151="bu siness",A151+30,A151+7)))

The second gives the sum of a range of cells (kindly donated in an
earlier thread).

=SUMPRODUCT(--(DAY(Main!$F$3:Main!$F$500)=A3),--(MONTH(Main!$F$3:Main!$F$500)=B3),Main!$D$3:Main!$ D$500)

I


I want a formula that only does the sum if the value in a cell is "yes".

Can anyone help me?