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!! |
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!! |
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!! |
All times are GMT +1. The time now is 07:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com