Not sure exactly what you're trying to do, but maybe something like this:

=COUNTIF(M1:M8,"Red")
=COUNTIF(M1:M8,"Orange")

HTH,
Paul


--

"Kelly" wrote in message
...
Result
1 Red
2 White
3 Red
4 Pearl
5 Green
6 Blue
7 Blue
8 Blue

Score -

Not sure how to do this -- I want to score colors. If 1 is Red, then add
a
point. If 2 is Orange, add a point. If 3 is Red, add a point, etc. I
thought I could use an If function but I can't get it to work.

Doesn't an if function work like =if(B1=Red,1,0)? I want the score for
all
8 colors to be added up. Does that make sense?

Thanks!!