Hi,

Try using countif(A:A,"J. Lang")


--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"caldog" wrote:

Hope this will be my last time to have to ask a question of you experts.

I have an individual name that I am trying to see if it is in a particular
column, if it is then just put a one, or what ever number of times it
appears. Sometimes there are two columns that I need to check if the name
appears, and then just add up all of the occurrences.

Example:

A B C D E
1. T. Bodie J. Lang None
2. T. O'Connell T. Bodie T. Spurgeon
3. M. Lalonde N. Martz
4. T. Spurgeon B. Geisler J. Lang
5. S. Slonina T. O'Connell B. Hodge

So what I want to do is see how many times say a J. Lang appears. And put
this number in a different spot on my spreadsheet.

Any help,

Thanks

Steve