Try..

=IF(B2="EX","",<your formula)

'or will this do?
=IF(AND(B2="EX",C69=1,C90<L3),L69,"")

--
Jacob (MVP - Excel)


"Mark D" wrote:

Good afternoon everyone

I am sure this is pretty simple but everything I am trying isn't working,
Hoping someone can help

I have the following formula

=IF(SUMPRODUCT(($C69=1)*($C90<L$3)),L69,"")

Works prefectly, But I want to add to the start of it

IF B2="EX","" otherwise run the sumproduct formula above

many thanks