If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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)*($C90L$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 |
#2
|
|||
|
|||
Adding an additional forumula to my SUMPRODUCT formula
Try..
=IF(B2="EX","",your formula) 'or will this do? =IF(AND(B2="EX",C69=1,C90L3),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)*($C90L$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 |
Thread Tools | |
Display Modes | |
|
|