One way:

=SUMPRODUCT(--(DAY(Main!$F$3:Main!$F$500)=A5),
--(MONTH(Main!$F$3:Main!$F$500)=B5),Main!$C$3:Main!$ C$500,
--(Main!$B$3:$B$500="Yes"))



In article ,
Martin Smith wrote:

I have the following formula giving me a total value of a range of
figures based on date:

=SUMPRODUCT(--(DAY(Main!$F$3:Main!$F$500)=A5),--(MONTH(Main!$F$3:Main!$F$500)=
B5),Main!$C$3:Main!$C$500)

I

want the totalisation to be done only if yes appears in another column.
I have used logic functions in the past but I am struggling to use it
in the above formula without it flagging an error or using the IF
function and I put the formula in for the true response it shows the
formula as text rather than doing the calculation.