Sum up results from If statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kelly - 25 Sep 2007 14:14 GMT

    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!!

Reply to this Message

Pete_UK - 25 Sep 2007 14:25 GMT

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

> Result
> 1 Red
[quoted text clipped - 16 lines]
>
> Thanks!!

Reply to this Message

PCLIVE - 25 Sep 2007 16:03 GMT

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

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

HTH,
Paul

> Result
> 1 Red
[quoted text clipped - 18 lines]
>
> Thanks!!

Reply to this Message