|
| 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
May 27th, 2010, 09:26 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
May 27th, 2010, 09:53 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 | |
|
|
Linear Mode
