Looking for some formula help with calculating wins and loses based on a series of games with a team.
In the example, Team A was played twice and both series' were won. In the case of Team B, one series was lost and one series was won.
Results in column G.
Any thoughts?
HTH
Regards, Jeff
Hi Jeff,
I'm not sure what you are after, as you already seem to have a COUNTIFS formula in the summary table in cols J and K.
Am I missing something?
Pete
Hi Pete,
Yes, I have the summary table counting up the values in column G, but I'm looking for a formula in column G to replicate the results which were placed manually.
Helper in H
in H2
=IF(C1=C2,H1,MAX($H$1:H1)+1)
in G2
=IF(H2<>H1,IF(COUNTIFS(H:H,H2,D:D,"W")>COUNTIFS(H:H,H2,D:D,"L"),"Won Series","Lost Series"),"")
Thank you John this works great.
You're very welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks