Hello and a sincere thank you in advance. I am using Excel 2013.
I am trying to analyse our golf league matchups - schedule. We are using some software that just randomized the matchups and the time slots. There are certain teams that play others too often and others not enough or at all. I am trying to identify which teams have played (or will play) which and how many times.
I am struggling to capture the match counts. There are 14 weeks and 10 teams. I have two columns representing each team per week and I want to get a numerical count of when they play another team.
I know that team 1 will play team 2 twice in this schedule. I am trying to figure out how to show that via formula. I've tested the following formula (over the span of the two weeks that I know they played) but it isn't working properly.
=SUM(COUNTIFS(L2:L6,{"=1,2"},M2:M6,{"=1,2"}),COUNTIFS(AB2:AB6,{"=1,2"},AC2:AC6,{"=1,2"}))
What am I missing?
I'd also like to replace the =1,2 with a reference to the cell value (which is 1,2) and simplify this.
Thank you so much for helping!!
Matt
Bookmarks