do you mean

=COUNTIF(A:A,B2)


--
HTH

Bob Phillips

"Mad-z" wrote in message
...
I am trying to count the number of data items in a given column given data
items in another column. Both data is in text format?