Dropping the lowest score from a gradebook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
=sum(A:A)-MIN(A:A)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dropping test scores 1
How to find the lowest number of a row and delete it automatically 1
Formula to add 4 lowest numbers from a column of 6 4
Finding Average of last 5 entries 11
Summing numbers dropping lowest and highest 2
Easy question: Sort ascending in a row? 3
My formulas in excel are suddenly not working. Help! 7
need help printing rows & headers w/macro 4

Back
Top