Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT with condition FIND(text) is false
Using Excel 2007
I want to do a sumproduct where one of the conditions is that "Dedicated" is NOT present in C:C. Dedicated can appear anywhere in the text and the text varies, so I am using a FIND. I am not sure how to do this? Here was my quess... =SUMPRODUCT((A:A="GOLDMAN")*(B:B=1)*(FIND(C:C<"De dicated))) Thanks, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT with condition FIND(text) is false
Go Bucks!!! wrote:
Using Excel 2007 I want to do a sumproduct where one of the conditions is that "Dedicated" is NOT present in C:C. Dedicated can appear anywhere in the text and the text varies, so I am using a FIND. I am not sure how to do this? Here was my quess... =SUMPRODUCT((A:A="GOLDMAN")*(B:B=1)*(FIND(C:C<"De dicated))) Thanks, The syntax for FIND is as follows: FIND(find_text,within_text,start_num) I would use this in your SUMPRODUCT(): ISERROR(FIND("Dedicated",C:C)) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT with condition FIND(text) is false
Using Excel 2007
Maybe this: =COUNTIFS(A:A,"goldman",B:B,1,C:C,"<*dedicated*") Note that an empty cell in column C will not contain dedicated so it could be counted if the corresponding cells in columns A and B meet their criteria. -- Biff Microsoft Excel MVP "Go Bucks!!!" wrote in message ... Using Excel 2007 I want to do a sumproduct where one of the conditions is that "Dedicated" is NOT present in C:C. Dedicated can appear anywhere in the text and the text varies, so I am using a FIND. I am not sure how to do this? Here was my quess... =SUMPRODUCT((A:A="GOLDMAN")*(B:B=1)*(FIND(C:C<"De dicated))) Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
SumProduct with Date Range and One Condition that is Text | Excel Worksheet Functions | |||
Keep cell blank if condition is false in IF function | Excel Discussion (Misc queries) | |||
VB find (true false) | Excel Worksheet Functions | |||
How can I get a cell locked if the condition is false? | Excel Worksheet Functions |