Sorry to trouble you but your assumption is not right. The numbers are not 1,
2 and 3
If the number 1 horse has the best time out of the other 20 horses the
number will be
1 in blue 2nd best the number will be 1 in red and 3rd green I would like to
separate
Theses 1s and count all the blues reds and greens.

--
SAlexander


"Mallycat" wrote:


Assuming your cells contain 1, 2 or 3 in the cell, just use a countif
statement

=countif(range,1) will tell you how many 1's etc


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=555169