Isnumber(find( but not "a",

[Long Nose]

Hi all,

Excel 2010

I am trying to use a wild card in a Sumproduct formula. It is working to find the "a" in a column and returning the expected value, but what I really want to do is exclude the "a" cells. Any ideas?

formula

=SUMPRODUCT(--(SUB580AAL_SubsSalesBySource.xlsx!$A$1:$A$3000="CM"),--(SUB580AAL_SubsSalesBySource.xlsx!$A$1:$A$3000<>""),--ISNUMBER(FIND("A",SUB580AAL_SubsSalesBySource.xlsx!$C$1:$C$3000)),--(SUB580AAL_SubsSalesBySource.xlsx!$B$1:$B$3000=TYPE_S),--(SUB580AAL_SubsSalesBySource.xlsx!$E$1:$E$3000=Curr_Mo),--(SUB580AAL_SubsSalesBySource.xlsx!$F$1:$F$3000=Curr_YR),SUB580AAL_SubsSalesBySource.xlsx!$H$1:$H$3000)

This is the part I need to find a fix for. I need to exclude the "a".
--ISNUMBER(FIND("A",SUB580AAL_SubsSalesBySource.xlsx!$C$1:$C$3000)),

 

[Data Bender]

Just at a glance...

Replace ISNUMBER with ISERROR.

Thank you, T. Valko! This helped me. The following allowed me to return values conating "ABC" but not "XYZ":

=IF(AND(ISNUMBER(SEARCH("ABC",A6)),ISERROR(SEARCH("XYZ",A6))),A6,"")

 

[Aladin Akyurek]

Thank you, T. Valko! This helped me. The following allowed me to return values conating "ABC" but not "XYZ":

=IF(AND(ISNUMBER(SEARCH("ABC",A6)),ISERROR(SEARCH("XYZ",A6))),A6,"")

Also:

=IF(ISNUMBER(LOOKUP(9.99999999999999E+307,SEARCH({"ABC","XYZ"},A6))),A6,"")