| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Statement for Golf Scores | Excel Discussion (Misc queries) | |||
| Average Grades and drop the lowest score | Excel Worksheet Functions | |||
| Using Excel as a gradebook with ability to drop lowest grade | Excel Discussion (Misc queries) | |||
| "Drop the lowest" in computing average | Excel Worksheet Functions | |||
| Finding the average by dropping the lowest | Excel Worksheet Functions | |||
Linear Mode
