Try this:

=COUNTIF(A1:A300,"A1")

--
Biff
Microsoft Excel MVP


"ksean" wrote in message
...
Is there a way to use a formula to determine how many times an
alphanumeric
value is used in a column of cells.

For example a column consisting of 300 cells that have one of the folloing
notations in each cell "A1, A2, B1, B2, B3, C1, C2 or C3".

Can a formula be used to determine how many times A2 appears in the column
if so what formula would I use?

Can a formula be used to determine how many times A1 or B3 or C2 appears
in
the column if so what formula would I use?