Counting from list entries

R

rotors

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?
 
R

Roger Govier

Hi

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

Change range and expected value to suit.
 
Top