Originally Posted by
Sambo kid
I think I got what you want, see workbook.
I just added a couple additional countifs to your countifs formula, added a countfis for the no results, my interpretation of what you wrote above is that W and L in columns D and E in the points table didn't need changing. Also in I4 I put in a list of the team names as they appear in your Fixture tab so you don't have to keep changing the formulas, just point to I4 and drag down. So they are not visible I color coded the font to white so they match the fill color and are not visible.
Bookmarks