LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find the 10 lowest of 20 numbers in column and enter those 10 in a shred77 Excel Worksheet Functions 14 October 21st 07 09:47 PM
How do you add the three lowest numbers in a column? Bearkat Excel Worksheet Functions 2 April 6th 06 05:07 PM
Lowest numbers One-Leg Excel Discussion (Misc queries) 7 May 26th 05 08:06 PM
I need a formula to add the 3 lowest numbers out of 5. Humbie Excel Worksheet Functions 1 March 12th 05 05:41 PM
Formula for comparing 3 numbers and resulting in the lowest of the tbible Excel Worksheet Functions 2 November 18th 04 07:08 PM


All times are GMT +1. The time now is 05:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"