ExcelBanter - Eliminating the high 4 values

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Eliminating the high 4 values (https://www.excelbanter.com/excel-worksheet-functions/183148-eliminating-high-4-values.html)

Dick Gwin

Eliminating the high 4 values

Need help with a formula which sums the values in a range eliminating the 4
high values in the range.
Excel 2000- Thanks in advance

Gaurav[_2_]

Eliminating the high 4 values

There may be a better way but this works.

Assuming your range is A1:A10. you can change it as per the need.

=SUM(A1:A10)-SUM(LARGE(A1:A10,1),LARGE(A1:A10,2),LARGE(A1:A10,3 ),LARGE(A1:A10,4))

Does that help?

"Dick Gwin" wrote in message
...
Need help with a formula which sums the values in a range eliminating the
4 high values in the range.
Excel 2000- Thanks in advance

Gord Dibben

Eliminating the high 4 values

Shorter version.

=SUM(A1:A10)-SUM(LARGE(A1:A10,{1,2,3,4}))

Gord Dibben MS Excel MVP

On Wed, 9 Apr 2008 17:21:27 -0600, "Gaurav" wrote:

There may be a better way but this works.

Assuming your range is A1:A10. you can change it as per the need.

=SUM(A1:A10)-SUM(LARGE(A1:A10,1),LARGE(A1:A10,2),LARGE(A1:A10,3 ),LARGE(A1:A10,4))

Does that help?

"Dick Gwin" wrote in message
...
Need help with a formula which sums the values in a range eliminating the
4 high values in the range.
Excel 2000- Thanks in advance

All times are GMT +1. The time now is 04:21 PM.