Hi, I am trying to find the top 25% fastest times of these items then find the average.
I know I can find the average by doing an averageifs
=(AVERAGEIFS(C2:C25,A2:A25,"MA",B2:B25,"NW"))
But now I need to separate out the Top 25% fastest times.
Then take the average again. How would I do this in one equation?
Would I use the quartertile function?
Any help is greatly appreciated. Thanks!
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
I know I can find the average by doing an averageifs
=(AVERAGEIFS(C2:C25,A2:A25,"MA",B2:B25,"NW"))
But now I need to separate out the Top 25% fastest times.
Then take the average again. How would I do this in one equation?
Would I use the quartertile function?
Any help is greatly appreciated. Thanks!
Res | Type | time |
MA | ST | 37.5 |
LB | NW | 48.1 |
MA | ST | 50.4 |
LB | NW | 55.2 |
MA | ST | 43.375 |
ZU | NW | 53.375 |
MA | ST | 36 |
ZU | NW | 166.5417 |
MA | ST | 25.85417 |
MA | ST | 25.625 |
MA | ST | 31.375 |
MA | ST | 38.875 |
MA | ST | 53.64583 |
RT | NW | 79.4375 |
MA | ST | 45.9 |
MA | ST | 23.125 |
MA | ST | 32.79167 |
MA | ST | 40.27083 |
LB | NW | 43.416 |
MA | NW | 66.375 |
UB | NW | 59.20833 |
LB | NW | 58.6666 |
LB | NW | 59.39583 |
UB | ST | 40.77083 |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>