=AVERAGE(IF(AND(D4:D150,D4:D15<X1,D4:D15Y1),D4: D15))

That won't work. AND doesn't return an array, it returns a single value,
either TRUE or FALSE. So, *every* argument must evaluate to TRUE. In this
case it will *always* return FALSE because at least one value will never be
less than the MAX and one value will never be greater than the MIN value.


--
Biff
Microsoft Excel MVP


"Pete_UK" wrote in message
...
You could try this variation:

=AVERAGE(IF(AND(D4:D150,D4:D15<X1,D4:D15Y1),D4:D 15))

whe
X1: =MAX(D4:D15)
Y1: =MIN(D4:D15)

By the way, doesn't you range cover more than 10 numbers?

Hope this helps.

Pete

On Feb 6, 4:49 pm, Shu of AZ
wrote:
In the example below, there are 8 of a possible 10 numbers. The amount
varies but never more than 10. These numbers represent a value of an
equation earlier on in the worksheet. I need to be able to formulate the
average of these numbers after the high and low has been removed. In this
case, 52.28 would not be used nor would 50.81. I currently use
{=AVERAGE(IF(D4:D150,D4:D15))} to do the average of all but need to
remove
the high and low automatically. Can anyone assist in this? Thanks in
advance.

51.32
51.54
51.74
50.93
52.28
51.07
51.85
50.81
Blank
Blank
= Average with the high and low taken out