index/match to compile division records for fantasy football

I have a doozey for you guys, I think.

I am working on compiling records for my fantasy football league, and I’m trying to track division records.

In F707:O717 I have the total overall records. Our league is divided into two divisions. I have color coded them just so you can see the separation. There isn’t any vba to tie the colors to the names.

In other areas of the worksheet there are index/match formulas that do a similar task, like in AG511:AG515.

So what I’m looking to do is to have each owner’s records against the other teams in their own division computed. All of our games take place in columns F through V.

I hope I have provided enough information for you. If not, please feel free to ask and I’ll explain everything that I can to the best of my ability.

Thanks,
Damian