ExcelBanter - Adding an additional forumula to my SUMPRODUCT formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Adding an additional forumula to my SUMPRODUCT formula (https://www.excelbanter.com/excel-worksheet-functions/264701-adding-additional-forumula-my-sumproduct-formula.html)

Mark D[_2_]

Adding an additional forumula to my SUMPRODUCT formula

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

Jacob Skaria

Adding an additional forumula to my SUMPRODUCT formula

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

All times are GMT +1. The time now is 09:43 PM.