| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| possible have sum and average at bottom? | Excel Discussion (Misc queries) | |||
| What happened to the sum/count/average calculator at the bottom? | Excel Discussion (Misc queries) | |||
| in the average sum etc at bottom of sheet add a custom tab | Excel Worksheet Functions | |||
| calculating average on bottom 50% of data | Excel Discussion (Misc queries) | |||
| Average top 10 or bottom 10 | Excel Worksheet Functions | |||
Linear Mode
