Wildcard in Nested functions
 

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'!D2:D141="*EASE Dev*"),1)),(COUNT(IF('RTM Log'!B2:B141=1)*('RTM
Log'!C2:C141="Re-open")*('RTM Log'!D2:D141="*EASE Dev*"),1)))

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'!D2:D141)))

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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'!D2:D141="*EASE Dev*"),1)),(COUNT(IF('RTM Log'!
B2:B141=1)*('RTM
Log'!C2:C141="Re-open")*('RTM Log'!D2:D141="*EASE
Dev*"),1)))
.

One way (not array-entered):

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


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


In article ,
"W" wrote:

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'!D2:D141="*EASE Dev*"),1)),(COUNT(IF('RTM Log'!B2:B141=1)*('RTM
Log'!C2:C141="Re-open")*('RTM Log'!D2:D141="*EASE Dev*"),1)))

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

"Jason Morin" wrote:

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'!D2:D141)))

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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'!D2:D141="*EASE Dev*"),1)),(COUNT(IF('RTM Log'!
B2:B141=1)*('RTM
Log'!C2:C141="Re-open")*('RTM Log'!D2:D141="*EASE
Dev*"),1)))
.