Extracting the most recent score from a multiple criteria maxifs formula

Hi all.

I'm looking to extract a players most recent score from a table (TBLbenchpress).

This is the first section of the formula that returns the players max score in the table:

=MAXIFS(INDEX(TBLbenchpressSCORE,,$Q$9),TBLbenchpressSCORE[[Player]:[Player]],$C$2)

Because the table contains multiple players past scores, I then tried to add on a max date criteria to the end of the formula (to return that players most recent score):

=MAXIFS(INDEX(TBLbenchpressSCORE,,$Q$9),TBLbenchpressSCORE[[Player]:[Player]],$C$2,TBLbenchpressSCORE[Date],MAX(TBLbenchpressSCORE[Date]))

However, this didn't work. I've been playing around with is for some time, but I haven't had any success. Any suggestions?

Cheers