I am having a problem with my formula. I have a wrestling record book that I am trying to get points for. Example if a person won a match with a pin I want them to get 4 points. If they Lose a match they lose .5 points. I want to be able to add up points for Wins/Loses and How they won. The problem is the If/and statements do not add up the points.
I get the 3.5 for the Win/Loss but it doesn't add the the 4 points for the Pins. Can someone help?
<tbody>
</tbody>
So my code in I2 is {=SUM(IF((E2:E100="W"),2,0),IF((E2:E100="L"),-0.5,0),IF(AND(E2:E100="W",F2:F100="Pin"),2,0),IF(AND(E2:E100="W",F2:F100="TF"),1,0))}
I get the 3.5 for the Win/Loss but it doesn't add the the 4 points for the Pins. Can someone help?
Weight | Wrestler | Opponent | School | Result | How | Record | Pins | Points |
OP1 | W | Pin | 2-1 | 2 | ||||
Op2 | W | Pin | ||||||
OP3 | L | Dec |
<tbody>
</tbody>
So my code in I2 is {=SUM(IF((E2:E100="W"),2,0),IF((E2:E100="L"),-0.5,0),IF(AND(E2:E100="W",F2:F100="Pin"),2,0),IF(AND(E2:E100="W",F2:F100="TF"),1,0))}