Help with Averageif and Percentile

[Dspiller13]

Bare with me on explaning this. Trying to figure out how to combine averageif and percentile with certain criteria. Id like to average the numbers only in the 90th percentile, for that certain name, based on a names column, where the same names occur more then once. Ive tried =AVERAGEIFS(B1:B19,A1:A19,E2,B1:B19,">"&PERCENTILE(B1:B19,0.9))
E
John 2456. John.
John. 7556. Tyler
John. 6456
Tyler. 7546
Tyler 1775
Tyler 7577

 

[Eric W]

Welcome to the board.

Try:

=AVERAGEIFS($B$1:$B$19,$A$1:$A$19,E2,$B$1:$B$19,">"&PERCENTILE(IF($A$1:$A$19=E2,$B$1:$B$19),0.9))

confirmed with Control+Shift+Enter.