=average - eliminate the top and bottom number
 

Hello,

How do I write a formula that will average all numbers within a column as
well as remove the highest number and the lowest number?

Thanks

=average - eliminate the top and bottom number
 

=(sum(a:a)-min(a:a)-max(a:a)/(count(a:a)-2)

Regards,
Fred.

"Jim" wrote in message
...
Hello,

How do I write a formula that will average all numbers within a column as
well as remove the highest number and the lowest number?

Thanks

=average - eliminate the top and bottom number
 

Assuming you have the numbersin ColA ..

=(SUM(A:A)-MIN(A:A)-MAX(A:A)/(COUNT(A:A)-2))

If this post helps click Yes
---------------
Jacob Skaria


"Jim" wrote:

Hello,

How do I write a formula that will average all numbers within a column as
well as remove the highest number and the lowest number?

Thanks

=average - eliminate the top and bottom number
 

I think you have a closing parenthesis out of place.

--
Rick (MVP - Excel)


"Jacob Skaria" wrote in message
...
Assuming you have the numbersin ColA ..

=(SUM(A:A)-MIN(A:A)-MAX(A:A)/(COUNT(A:A)-2))

If this post helps click Yes
---------------
Jacob Skaria


"Jim" wrote:

Hello,

How do I write a formula that will average all numbers within a column as
well as remove the highest number and the lowest number?

Thanks

=average - eliminate the top and bottom number
 

Another one:

=TRIMMEAN(A1:A10,2/COUNT(A1:A10))

--
Biff
Microsoft Excel MVP


"Jim" wrote in message
...
Hello,

How do I write a formula that will average all numbers within a column as
well as remove the highest number and the lowest number?

Thanks

=average - eliminate the top and bottom number
 

Thanks Rick...

=(SUM(A:A)-MIN(A:A)-MAX(A:A))/(COUNT(A:A)-2)

If this post helps click Yes
---------------
Jacob Skaria


"Rick Rothstein" wrote:

I think you have a closing parenthesis out of place.

--
Rick (MVP - Excel)


"Jacob Skaria" wrote in message
...
Assuming you have the numbersin ColA ..

=(SUM(A:A)-MIN(A:A)-MAX(A:A)/(COUNT(A:A)-2))

If this post helps click Yes
---------------
Jacob Skaria


"Jim" wrote:

Hello,

How do I write a formula that will average all numbers within a column as
well as remove the highest number and the lowest number?

Thanks