CountIf question

[tjc154]

I'm trying do a count of cells in a range that contain the following variable \\AUTXFSWP01\. I tried the following formula but it retuns a value of "0"

=Countif(A2:A250,"\\AUTXFSWP01\"). I also tried removing the backslashes, but it still returns the same.

Is Excel not able to do a count when \ characters are used?

Thanks

Tom

 

[Jonmo1]

Will \\AUTXFSWP01\ be the ENTIRE contents of the cell?
Or will that appear mixed in with other text in the cell as well?

Perhaps you want

=Countif(A2:A250,"*\\AUTXFSWP01\*")

 

[niceguy_jay]

surprising...it is working fine for me ...i am getting the counts...
except that it takes "\\" as some address...but still it gives the right counts...
what can be the problem ????

 

[tjc154]

I have a path name that continues after the last back slash. Ex: \\AUTXFSWP01\data\Count
.
The formula in your first reponse works with the **characters.

Thank you

Tom