Thread: when doing a grade book how do you drop the lowest grade
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
  
Posts: 1,998
Default when doing a grade book how do you drop the lowest grade
=SUM(A1:A10)-SMALL(A1:A10,1)

hth
Vaya con Dios,
Chuck, CABGx3



"dove" wrote:

I am trying to do a grade worksheet. I am looking for the formula for
dropping the lowest grade

Reply With QuoteReply With Quote