formula

[Guest]

I’m writing a horse race program.
I can do as many as 20 horses in one race (or 20 rows)
In my program there are 15 categories (or 15 columns) where a horse can be
rated 1st, 2nd or 3rd which is conditionally formatted (Blue, Red and Green).
In other words a particular horse could have any number of blue, reds, or
greens in his section up to 15..
I’d like to be able to break this down to the point where I can generate a
number for each horse, corresponding to how many 1st, 2nd, or 3rds(blue, reds
and greens) a horse may have.
What formula would I use to count all the blues, reds and greens for each
horse and generate this into another section of my sheet?

 

[Mallycat]

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

 

[Guest]

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 1’s and count all the blues reds and greens.