Need help with formulas and functions

[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

 

[Dan E]

Greyhwk,

If your data were in A1:A5

=(SUM(A1:A5)-MIN(A1:A5)-MAX(A1:A5))/(COUNT(A1:A5)-2)

Dan E

 

[Ron Rosenfeld]

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

Well, C1:F1 only comprises four values. Assuming you want five values, then:

=AVERAGE(LARGE(C1:G1,{2,3,4}))

or

=TRIMMEAN(C1:G1,0.4)


--ron

 

[greyhwk]

Yep, I goofed. I only put in addresses for 4 values.

Thanks to those who answered. All the formulas worked and we have chosen to
go with the shortest one. I do hate typing you know. lol

greyhwk