One way:
=SUM(rng,-SMALL(rng,{1,2}))
or, equivalently (array-entered with CMD-RETURN):
=SUM(LARGE(rng, ROW(INDIRECT("1:"&COUNT(rng)-2))))
In article <ee99f4c.-1@[EMAIL PROTECTED]
>,
acpharmd@[EMAIL PROTECTED]
wrote:
> Version: 2008
> Operating System: Mac OS X 10.5 (Leopard)
> Processor: intel
>
> Gradebook help question. I need to calculate the mean of several scores
after
> dropping the two lowest scores. I found the MIN function, but cannot
> determine how to omit the TWO lowest.
> Thank you in advance.
|
