Counter Problem

  • Thread starter Thread starter Vic
  • Start date Start date
V

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.
 
Try this:

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

Does that work for you?
 
Try it like this (all on one line):

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