Sum up results from If statement
If the different colours represent different scores then you can use a
lookup table, starting in say cell M1:
Red 1
White 6
Pearl 5
Green 3
Orange 2
Blue 4
Put your scores in the next column as shown. Then in B1 (assuming your
colours are in A1), put this formula:
=VLOOKUP(A1,M$1:N$6,2,0)
and copy down.
Hope this helps.
Pete
On Sep 25, 2:14 pm, Kelly wrote:
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!!
|