Get highest value based on two columns

this appears to work for what you want... =MAXIFS($E$2:$E$40,$B$2:$B$40,"2020 Jul",$C$2:$C$40,"<>"&"total")
I don't like using table names because it makes it more difficult to debug (for me anyway) but this is it with the table names...
=MAXIFS(Table1[Amount2],Table1[Month],"2020 Jul",Table1[Agent],"<>"&"total")

In I4

=AGGREGATE(14,6,Table1[Amount2]/((RIGHT(Table1[Month],LEN($H$4))=$H$4)*(Table1[Agent]<>"TOTAL")),1)

Please try

=MAX(INDEX((RIGHT(Table1[Month],3)=H4)*(Table1[Agent]<>"Total")*Table1[Amount2],))

Originally Posted by kvsrinivasamurthy

In I4

=AGGREGATE(14,6,Table1[Amount2]/((RIGHT(Table1[Month],LEN($H$4))=$H$4)*(Table1[Agent]<>"TOTAL")),1)

Thank you so much. This worked like magic.

Sam Capricci and Bo_Ry, thank you guys too for taking the time to reply. I did not try Sam's method, as I don't have Office 2019, and I didnt try Bo's because I was more familiar with AGGREGATE and have used it in other parts of my sheet.