Counter Problem

[Vic]

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.

 

[JBeaucaire]

Try this:

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

Does that work for you?

 

[T. Valko]

Try it like this (all on one line):

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