How many records are used in a percentile

[dlatha01]

Hi Guys,

I'm running a formula to determine what the 90th Percentile is relative to a each team, in a table

How do I then show how many records are actually in the 90th Percentile ?


Formula for the percentile is
=PERCENTILE.INC(IF(Team=Comp,Values),0.9)


Thanks
D

 

[shg]

=countifs(team, comp, values, ">=" & thatNumber)