"Rick Rothstein (MVP -
VB)" wrote in
message ...
I am needing help; I use spreadsheets entering 6 scores and have to throw
out
the high and low and average the remaining 4. This I can do; BUT if we
add 6
more scores to the scenario making a total of 12, is there a way to throw
out
3 high and 3 low and average the remaining 6?
I think this formula will work...
=SUMPRODUCT(LARGE(A1:A12,{4,5,6,7,8,9}))/6
Change the range of cells to match the 12 cells you have you data in.
Rick
Average will work:
=AVERAGE(SMALL(A1:A12,{4,5,6,7,8,9}))
Or, the less known:
=TRIMMEAN(A1:A12,6/12)
--
Biff
Microsoft Excel MVP