Quote Originally Posted by meabrams View Post
Like this?

=COUNTIF(Clients!B4:B500,A1)
That will only return exact matches. I think the OP wants partial matches included in the count.