I need to have excel count the wins and losses in a column, and also work out the win percentage. However I have had to use an if statement as Im trying to make the excel document update from just one new cell
I have a working table, where I add the new value, it works out the difference from the previous value and then displays if its a win or loss based on the result. I cannot get the wins and losses to play nice with working out a percentage and being counted for total. I've tried simple things like "=counta(B:B, win,)" for counting and "=B:B/B:B" for percentage.
Im very new to excel and am trying to have detailed tracking of my SR changes and a Log of wins and losses for Overwatch, as the ingame analytics are not very good in this regard.
any and all help would be appreciated
https://drive.google.com/open?id=0B9...URta2ItanBkRFE
Download Button is in the top right corner
Link to download and have a look at it so far
Thanks for any and all help.
Bookmarks