Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum up results from If statement
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!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum up results from If statement
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you display IF statement results in a different cell | Excel Worksheet Functions | |||
IF statement colored results | Excel Worksheet Functions | |||
if/then statement that results in Yes/No | Excel Discussion (Misc queries) | |||
IF Statement with Average Function results in #Value! | Excel Discussion (Misc queries) | |||
adding if statement results | Excel Worksheet Functions |