Probably not.

=countif() will treat both numbers and strings as strings.

But if you have trailing/leading/multiple embedded spaces, then the strings
won't be equal.

Can you pick out a value you know that should be included in the count and see
if there's something else in that cell?



cware wrote:

Hi, I cannot get this to work. I thought it would be this easy as well....I
actually started out with this exact statement. Will it matter if my client
code is alpha and not numerical?

"Luke M" wrote:

Something like this on "By Client" worksheet in row2

=COUNTIF('Raw Data'!C:C,A2)

And then copy down as needed.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"cware" wrote:

Hi all. Thanks in advance for your help.

I have a workbook with two sheets
"By Client" has column A which is a list of client codes
"Raw Data" has 35000 lines of data where each line will include a client
code in column C.

On "By Client" I want to count how many times that client code shows on "Raw
Data".

I have already used a pivot table to get the list of client codes I want to
use, put I need to take this additional step.

Appreciate your assistance.


--

Dave Peterson