| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula to add 4 lowest numbers from a column of 6
Hi,
Try this, change the range to suit =SUM(SMALL(B1:B6,{1,2,3,4})) Mike "Mike" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula to add 4 lowest numbers from a column of 6
I get the following error #NAME?
any suggestions? "Mike H" wrote: Hi, Try this, change the range to suit =SUM(SMALL(B1:B6,{1,2,3,4})) Mike "Mike" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula to add 4 lowest numbers from a column of 6
Suggestion number 1 is that instead of copying the formula from newsgroup to
the formula bar of the spreadsheet you tried to retype it and mis-spelled something. Suggestion number 2 would be that you have an error in a formula in one of the cells leading into the formula, so that the #NAME? error occurs somewhere in the B1:B6 range. -- David Biddulph "Mike" wrote in message ... I get the following error #NAME? any suggestions? "Mike H" wrote: Hi, Try this, change the range to suit =SUM(SMALL(B1:B6,{1,2,3,4})) Mike "Mike" wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula to add 4 lowest numbers from a column of 6
Did you paste it exacly as posted. Small doesn't require the analysis toolpak
so make sure a rogue spaces hasn't got into SU M or SM ALL Mike "Mike" wrote: I get the following error #NAME? any suggestions? "Mike H" wrote: Hi, Try this, change the range to suit Mike "Mike" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find the 10 lowest of 20 numbers in column and enter those 10 in a | Excel Worksheet Functions | |||
| How do you add the three lowest numbers in a column? | Excel Worksheet Functions | |||
| Lowest numbers | Excel Discussion (Misc queries) | |||
| I need a formula to add the 3 lowest numbers out of 5. | Excel Worksheet Functions | |||
| Formula for comparing 3 numbers and resulting in the lowest of the | Excel Worksheet Functions | |||
Linear Mode
