View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Formula to add 4 lowest numbers from a column of 6

I am a golf coach and am trying to figure out how to add the 4 lowest scores
to come up with the team score for my HS golf team.
I understand the simple sum formulas but do not know how to get it to pull
out the 4 lowest scores and total them from a column of 6 numbers.

Any help would be appreciated!

Thanks