Thanks it worked great however now I need to expand the search across 2
columns on a different sheet.

For example:
I need cell B5 on sheet 'stock' to tell me how many times column D on sheet
'Master' displays "blue" and column E displays "frisbee". I am trying to
determine how many times "blue" and "frisbee" appear on the same row side by
side.

Thanks,
Kerry




"Gary''s Student" wrote:

=COUNTIF(A1:A300,"A1")
etc.
--
Gary''s Student - gsnu200907


"ksean" wrote:

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?