Hi. I'm getting an error for a combined Countif, Index & Match formula. The error is occurring in 'Leaderboards", cells O7:X20, I can't determine what's wrong. I need the cells on that spreadsheet to reference the cells in "Games", even after those cells have been sorted in whatever order, & to stay correct to the relevant person. Cell O7 in "Leaderboards" is counting how many times the word '1st' appears in the 'Pos' columns in "Games'. Cell P7 is counting how many times the word '2nd' appears in the 'Pos' columns in "Games". Cell Q7 is counting the word '3rd' and so on. I would also like any blank cells to show blank & not 0.
Solved by K. J. in 27 mins