What is wrong with this formula?
='DCFs-Sym'!G87&"
("&SUMPRODUCT(ISNUMBER(SEARCH("RTR",'DCFs-Sym'!J92:J2002,1)))&")"
The result should look like this: 1802 (782)
But I now see: 1802 (0)
I do have 782 text cells in J92:J2002 range that contain RTR in them.
Can someone please help me with this?
Thank you.

Try this:

='DCFs-Sym'!G87&" (" & COUNTIF('DCFs-Sym'!J92:J2002, "*RTR*") & ")"

Does that work for you?
--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"Vic" wrote:

What is wrong with this formula?
='DCFs-Sym'!G87&"
("&SUMPRODUCT(ISNUMBER(SEARCH("RTR",'DCFs-Sym'!J92:J2002,1)))&")"
The result should look like this: 1802 (782)
But I now see: 1802 (0)
I do have 782 text cells in J92:J2002 range that contain RTR in them.
Can someone please help me with this?
Thank you.

Try it like this (all on one line):

='DCFs-Sym'!G87&" ("&SUMPRODUCT(
--ISNUMBER(SEARCH("RTR",'DCFs-Sym'!J92:J2002,1)))&")"


--
Biff
Microsoft Excel MVP


"Vic" wrote in message
...
What is wrong with this formula?
='DCFs-Sym'!G87&"
("&SUMPRODUCT(ISNUMBER(SEARCH("RTR",'DCFs-Sym'!J92:J2002,1)))&")"
The result should look like this: 1802 (782)
But I now see: 1802 (0)
I do have 782 text cells in J92:J2002 range that contain RTR in them.
Can someone please help me with this?
Thank you.