Max of sumif array with multiple criteria

Ok, I know I am asking a lot with this question so I am going to thank you up front. Thank You!

In the file I attached below I have a list of names, each name then has a owner and games played for that owner per year. For the All Time Stats (starting at N) I need to find the players owner based first off games player, and if there is a tie wins.

I have been working on this for a while and I am getting nowhere.

I have been trying a named list so I made a list of all the owners. I also worked out and highlighted what the answers should be for this example in the bottom right corner

Thank you again.

Put this formula in cell Z28:

=SUMIFS($F:$F,$A:$A,$Y28,$B:$B,Z$27)

then copy across and down.

Hope this helps.

Pete

Thanks you Pete,

I agree that is a better formula then what I have, but the little chart in the bottom right corner is just an example of what the answers should be for this small sample size. The Cells I need a formula for are N2:N5

Sorry for the confusion

=MAX(SUMIFS($F$2:$F$37,$A$2:$A$37,$M2,$B$2:$B$37,$Y$15:$Y$19))

Enter with Ctrl+Shift+Enter.

Phuocam

Thank you. I was getting held up there so I will keep working on it. I know I will need to use an Index/Match to get the name, I am assuming countif to see if there is a tie at the top(not sure about this part), and then I will just repeat the process for the tiebreaker.

I'll let you know what I come up with.

I am racking my brain on this and not getting anywhere. How do I determine if there is a tie. I use the formula at that part works, but now I need to determine if the max occurs more then once, example N5, both Drew Brees and Hank Hill have 17 games played.

=COUNT(MAX(SUMIFS($F$2:$F$37,$A$2:$A$37,$M5,$B$2:$B$37,$Y$15:$Y$19)),(SUMIFS($F$2:$F$37,$A$2:$A$37,$M5,$B$2:$B$37,$Y$15:$Y$19)))

I thought this was working but it just turns out 2 is the only answer it will give. Please help.

I am currently working in O but the answer will ultimately be in N I am just using the neighboring cells to work through my progressions

So I have a solution, I gave up on trying to do this all in one cell and created a new sheet that matches the table I have in the bottom right hand corner of the sheet attached. I wanted to avoid this as it will probably triple the size of file and I might end up pulling it all out into a new file that just get referenced.

That said doing this made it easy to get the solution I was looking for. Thank you for all the help everyone.