i have a spreadsheet for a sports team. i have the formula for scores example. A2 = 13, B2 = 7. IF(A2>B2,”Win”,IF(B2>A2,”Loss”,IF(A2=B2,”Draw”))). So this = Win

i have three different games. first result = Win, second & third result = Loss.

i am trying to figure out the formula so i can have total “Win” divided by total games.

By: Jackson Bryant-Kelly

Edit:

i have a spreadsheet for a sports team. i have the formula for scores example. A2 = 13, B2 = 7. IF(A2>B2,”Win”,IF(B2>A2,”Loss”,IF(A2=B2,”Draw”))). So this = Win

i have three different games. first result = Win, second & third result = Loss.

i am trying to figure out the formula so i can have total “Win” divided by total games.

i am trying to determine our win percentage, without having to manually input.