Wildcard in Nested functions

[Guest]

Need to count the number of occurences.
When using the wildcard always returns a 0.
Can someone please help.
=SUM(COUNT(IF('RTM Log'!B2:B141=1)*('RTM Log'!C2:C141="Open")*('RTM
Log'!D2141="*EASE Dev*"),1)),(COUNT(IF('RTM Log'!B2:B141=1)*('RTM
Log'!C2:C141="Re-open")*('RTM Log'!D2141="*EASE Dev*"),1)))

 

[Jason Morin]

Unfortunately you can't use wildcards that way. Try the
ISNUMBER-SEARCH approach. I re-worked your formula to be:

=SUM(('RTM Log'!B2:B141=1)*('RTM Log'!C2:C141={"Open","Re-
open"})*ISNUMBER(SEARCH("ease dev",'RTM Log'!D2141)))

Array-entered (press ctrl + shift + enter).

HTH
Jason
Atlanta, GA

 

[JE McGimpsey]

One way (not array-entered):

=SUMPRODUCT(--('RTM Log'!B2:B141=1),--('RTM Log'!C2:C141="Open"),
--ISNUMBER(SEARCH("EASE Dev",'RTM Log'!D2141)))


For an explanation of the "--" see
http://www.mcgimpsey.com/excel/doubleneg.html

 

[Guest]

I am sorry that did not work. It still returned a 0. Do you have any other
ideas? Thanks for the help.