| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
when doing a grade book how do you drop the lowest grade
I am trying to do a grade worksheet. I am looking for the formula for
dropping the lowest grade |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
when doing a grade book how do you drop the lowest grade
=SUM(A1:A5)-MIN(A1:A5) would drop the lowest grade from that range, if you
want to sum. Ex.: A1 = 100 A2 = 100 A3 = 100 A4 = 100 A5 = 99 =SUM(A1:A5)-MIN(A1:A5) -- 499 - 99 = 400 Dave -- Brevity is the soul of wit. "dove" wrote: I am trying to do a grade worksheet. I am looking for the formula for dropping the lowest grade |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| when doing a grade book how do you drop the lowest grade | Excel Worksheet Functions | |||
| linking multiple books (source.xls) to a single book (destination. | Excel Discussion (Misc queries) | |||
| book selection when using move or copy tab in excel | Excel Worksheet Functions | |||
| Grade book average formula | Excel Worksheet Functions | |||
| Do any of the Grade book templates using Excel average grades? | Excel Discussion (Misc queries) | |||
Linear Mode
