COUNTIF ignoring certain text

[KyleMcCarthy]

Hello,

I have the following COUNTIF that works well, but recently realized it's not useful given there are duplicates, thus throwing off my numbers.

=COUNTIF($A$1:$X$145, "*"&A213&"*")

I have a table of text spanning from A1 through X145 of server names. Given the server, the exact name could show up multiple times.
The problem is as follows:

I have a server named ABCLOG, that on it's own, shows up seven times. But then I have another server named ABCLOGOffsite that shows up 3 times, and another server named ABCLOGWarmsite that shows up three times.

The goal is to have each server's EXACT name display the amount of times it shows up. However, when I do it, ABCLOG returns a number of 13 instead of seven.

 

[AhoyNC]

Is it just the server name in the cells, if so try:

=COUNTIF($A$1:$X$145,A213)

 

[KyleMcCarthy]

I tried that, it doesn't work =(

 

[DanteAmor]

I suppose you have 4 cases to count:
"ABCLOG"
"ABCLOG space" any
any "space ABCLOG"
any "space ABCLOG space" any


Try:

=COUNTIF($A$1:$X$145,A213)+COUNTIF($A$1:$X$145,A213&" *")+COUNTIF($A$1:$X$145,"* "&A213)+COUNTIF($A$1:$X$145,"* "&A213&" *")