Hi
Try something like this:
=COUNTIF(A2:A2000,"White")

--
Andy.


"Ralph Smith" wrote in message
...
I have a column of colors:

White
Red
Yellow
Yellow
Black
Red
White
Red
Red
Black
Black
Black
White
White
White

Is there a formula for determining how many of each color appear in
the column?

Thanks in advance.