How do I set up a formula to throw out the 2 lowest scores?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rineay - 15 Jun 2006 16:55 GMT

I would like to enter 8 quiz grades throw out the two lowest scores and get
the average of the 6 remaining scores.

I know there's got to be a way to do this, I just haven't figured it out
yet. Any help would be appreciated

I am using Excel 2003.

Reply to this Message

Ron Coderre - 15 Jun 2006 17:08 GMT

Try this:

For scores in A1:H1

I1: =AVERAGE(LARGE(A1:H1,{1,2,3,4,5,6}))

Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP

> I would like to enter 8 quiz grades throw out the two lowest scores and get
> the average of the 6 remaining scores.
[quoted text clipped - 4 lines]
> I am using Excel 2003.
>

Reply to this Message