Say the drop downs are in Column A,
In B1 to B5 enter A to E,
Then in C1, enter:

=Countif(A:A,B1)
And copy down to C5.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Zoltan" wrote in message
...
I have a column of drop down lists with 5 possible entries, say "A", "B",
"C", "D" and "E". I am trying to return a total count for each of the 5
possible entries in the column. Any ideas how I might be able to do this?
Hope this makes sense. Cheers!