Summation of 25 highest values out of total data of 35

[Manoj Shedbalkar]

Hi,

I have a data of 35 values and I want to consider only top 25 values.

Data is spread as 35 agents and their scores across 3 months (in
Pivot) so cannot use Sort function each and Every time.

Please help.

Manoj.

 

[Ron Rosenfeld]

Hi,

I have a data of 35 values and I want to consider only top 25 values.

Data is spread as 35 agents and their scores across 3 months (in
Pivot) so cannot use Sort function each and Every time.

Please help.

Manoj.

How best to do this depends on information you have not yet shared with us, such as your data layout, and Excel version.

For example, if your values are in column A, and your dates in column B, and you want to find the average of the top 25 for the fourth quarter of 2010, and your Excel version is 2007 or later, you could use:

=AVERAGEIFS(A:A,A:A,">="&LARGE(A:A,25),B:B,">=" & DATE(2010,9,1),B:B,"<="&DATE(2010,12,31))

Formulas also exist for earlier versions and this could be modified to include different ranges or criteria.