Need help with formula and functions =AVERAGE

  • Thread starter Thread starter greyhwk
  • Start date Start date
G

greyhwk

I am building a testing chart for equipment.
I have 5 tests on each item and have to put in their numerical value.
I need to average the values dropping the highest and lowest values as
sometimes the values can be a misread of the test equipment.

The question is, is ther are formula, argument or function that can be as
follows:
=AVERAGE (C1:F1) ignore =MIN(C1:F1) and =MAX(C1:F1)

I have been looking through the help built in to Excel and have not had
success in finding the answer.

greyhwk
 
A couple of ways

=TRIMMEAN(C1:F1,2/COUNT(C1:F1))

or

=(SUM(C1:F1)-MAX(C1:F1)-MIN(C1:F1))/(COUNT(C1:F1)-2)

regards,

Peo Sjoblom
 
First of all, C1:F1 contains only 4 values<g>.

Hold down the Ctrl and Shift when entering the following formula.

=AVERAGE(LARGE(B1:F1,{2,3,4}))

Regards,
David Hager
Excel FMVP
 
David and Peo,

That's three of us FMVPs answering one question! - These slow news servers
really are a drag.

Take care - hopfully, we'll all be back sometime soon.

Bernie
 
greyhwk said:
I am building a testing chart for equipment.
I have 5 tests on each item and have to put in their numerical value.
I need to average the values dropping the highest and lowest values as
sometimes the values can be a misread of the test equipment.

The question is, is ther are formula, argument or function that can be as
follows:
=AVERAGE (C1:F1) ignore =MIN(C1:F1) and =MAX(C1:F1)

I have been looking through the help built in to Excel and have not had
success in finding the answer.

greyhwk
Click to expand...

Give this a try.

=-(AVERAGE(C1:F1)-MAX(C1:F1)-MIN(C1:F1))
 
Back
Top