Dropping the lowest score from a gradebook
 

I have a gradebook that I am working on and would like to write a formula
that will drop the lowest score from a column. Does anyone have any
suggestions?

Dropping the lowest score from a gradebook
 

=sum(A:A)-MIN(A:A)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Stockeyd" wrote in message
...
I have a gradebook that I am working on and would like to write a formula
that will drop the lowest score from a column. Does anyone have any
suggestions?

Dropping the lowest score from a gradebook
 

If you're looking to find the average grade amongst many, then Bob was
correct, but you'll want to add:

=(SUM(A#:A#)-MINA(A#:A#))/(COUNT(A#:A#)-1)

where # = the row numbers in the array. Otherwise you'll just have a total
sum of the points.

You can format the cells to limit the amount of remaining decimals places as
well if you like.

Aaron

"Bob Phillips" wrote:

=sum(A:A)-MIN(A:A)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Stockeyd" wrote in message
...
I have a gradebook that I am working on and would like to write a formula
that will drop the lowest score from a column. Does anyone have any
suggestions?