I am totally confused by that Bob. As a total novice I am not sure what you
mean by 2:2 etc - Could you possibly explain? Cheers and thanks for your help
so far.

"Bob Phillips" wrote:

=COUNTIF(2:2,1)

=COUNTIF(2:2,"A")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Anne-Marie" wrote in message
...
I am not trying to find the sum of numbers but want to evaluate how many
number 1s, 2s etc that I have without having to count manually. Also would
like to do the same with letters. Any suggestions would be much
appreciated.