Find & Count the number of times a text string appears in a named range

[tronchetti]

Hello all,
I have a named range called history, and I need to create a formula that will search this range and find & count the number of times the search string is found. The problem with the formula I tried is I'm getting false matches. See example.

B20 contains the string I need to match
B20: Outside-Acc-TXMATES

The formula in D20 is: =SUMPRODUCT(--(ISNUMBER(SEARCH(B20,history))))

The result in D20 = 30, but they are all false matches to cells in the history range that contain this string - Outside-Acc-TXMATES-Temp

 

[shg]

but they are all false matches

The are not false matches, right? They do indeed contain the sought string.

If you want cells than contain only that value, =countif(history, B20)

 

[mumps]

Try: =COUNTIF(history,B20)

 

[tronchetti]

The are not false matches, right? They do indeed contain the sought string.

If you want cells than contain only that value, =countif(history, B20)

Thank you, I think I over complicated it

 

[tronchetti]

Thank you, I think I over complicated it