Max value using COUNTIF formula

[Dishboy09]

Needing some help to figure out this formula.

I am using COUNTIF currently of this =COUNTIFS(AF:AF,T6,AT:AT,">0") to find # of 0-1 values in columns. This certain part of my sheet uses a different setup. This particular one gives a certain # but on say half of the entries. I need a max value formula to search the same criteria in the countif but find the max value associated with T6 from AF:AF in AT:AT??

THANKS!

 

[Dishboy09]

All the ranges need to be the same size.

Well that made it click in my head! I believe I have it working now.

Thanks!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Candyman8019]

Give this a try, in this example, column A has the list of names and column B has the scores:
row 2: bob 50
row 3: bob 25
row 4: john 60
row 5: steve 70


=MAXIFS($B$2:$B$5,$A$2:$A$5,A2)