| 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 | |||
![Mark D[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
