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.