Good morning,
I have a list of dates column B, and a list of outcomes in Column H. The outcomes include "win" and "loss".
Can I get a win % result to always update for the past 7 days only...
Thanks in advance!
Good morning,
I have a list of dates column B, and a list of outcomes in Column H. The outcomes include "win" and "loss".
Can I get a win % result to always update for the past 7 days only...
Thanks in advance!
Last edited by JoeT15; 06-10-2019 at 12:08 PM.
Sure. Try this:
=COUNTIFS(H:H,"win",B:B,">="&TODAY()-7)/SUM(COUNTIFS(H:H,{"win","loss"},B:B,">="&TODAY()-7))
thank you, i'm getting a 100% result, but the last 7 days list the following:
6/3 Win
6/4 Win
6/4 Loss
6/4 Win
6/6 Win
6/6 Win
6/6 Loss
6/6 Loss
6/7 Win
6/7 Loss
6/7 Win
6/8 Loss
6/8 Win
6/8 Loss
6/8 Tie
6/9 Win
6/9 Win
6/9 Win
6/9 Win
6/9 Win
6/9 Win
6/9 Win
6/9 Win
Is it possible to factor out any "tie" results as well..
Thanks for your help @63falcondude !
Strange... I'm getting 73%. It already factors out ties.
See attached.
hm okay, i see. It works in Excel, but when i upload through Google Sheets, it changes to 100% for some reason...
Screenshot attached
Attachment 627737
Google Sheets and Excel are not the same... There was no mention that you were using a different software here.
You can try this but I can't make any guarantee that it will work:
=COUNTIFS(H:H,"win",B:B,">="&TODAY()-7)/COUNTIFS(H:H,"<>tie",B:B,">="&TODAY()-7)
sorry i should have mentioned it. Thank you so much for the help, this worked perfectly!!
You're welcome. Happy to help.
In the future, questions about other platforms should be posted here:
https://www.excelforum.com/for-other...mobile-os-etc/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks