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