Hi

Try
=COUNTIF(A:A,"A")
to pick up all the A's entered in column A.

Change range and expected value to suit.
--
Regards

Roger Govier


"rotors" wrote in message
...
I have an identical drop down list of items (eg. "A" to "G") being used
on a
number of different workbook sheets. Is there a way to tabulate/count
the
different individual entries (i.e. how many "A"s, "B"s, etc) and what
function would I use?