Guys,

I have a question regarding the sumproduct formula.
Here is the situation;
considering the following data set;
$0.00 (D66)
$0.00 (D67)
$14.00
$18.75
$18.25
$20.00
$20.00 (D72)
I am computing the adjusted average for the above data set discounting zeros
and the max outlier.
My formula is

SUMPRODUCT((D66:D720)*(D66:D72<MAX(D66:D72))*D66: D72)/SUMPRODUCT((D66:D720)*(D66:D72<MAX(D66:D72)))

In the situation described above, it must take 14 as the outlier and discard
as that is more qualitatively appropriate.
So my question is, can the sumproduct check for the max and min outlier,
discard whichever is farthest from the simple average (simple average too
discards zeros), discard zeros, and then give me the adjusted average???