Home |
Search |
Today's Posts |
|
#1
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)*($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 |
#2
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,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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding to a SUMPRODUCT formula | Excel Worksheet Functions | |||
additional conditions to SUMPRODUCT formula | Excel Discussion (Misc queries) | |||
Please help with Sumproduct, adding additional criteria | Excel Worksheet Functions | |||
SUMPRODUCT - Additional criteria | Excel Worksheet Functions | |||
Additional Sumproduct Criterias | Excel Worksheet Functions |