Counting from list entries
 

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?

Counting from list entries
 

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?

Counting from list entries
 

=SUMPRODUCT(--(LEFT(A1:A500)="a"))
=SUMPRODUCT(--(LEFT(A1:A500)="b"))


etc.
--
Gary''s Student
gsnu200712