View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 380
Default 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?