Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with formula
I am doing a Golf outing for my aunt. She has a list of scores across a row
and I will need to find the 3 lowest scores and divide the total by 3 and subtract the par for that cousre to come up with their handicape. thank you in advance. Exp. 42, 44, 42. 40, 45, 41, 47, 45, 42, 44, 42, 45, 45, Take 40+41+42 =123 divide by 3 = 41 - 36 handi cap is 5. |
#2
|
|||
|
|||
=SUM(SMALL(A1:A13,1),SMALL(A1:A13,2),SMALL(A1:A13, 3))/3-36
This assume the set is in A1-A13. Small is the same as MIN but you choose which number you want (SMALL(A1:A13,2) is the second smallest). If you had two 40's in your list SMALL(A1:A13,1) and SMALL(A1:A13,2) would both be 40. "Mike Busch" wrote: I am doing a Golf outing for my aunt. She has a list of scores across a row and I will need to find the 3 lowest scores and divide the total by 3 and subtract the par for that cousre to come up with their handicape. thank you in advance. Exp. 42, 44, 42. 40, 45, 41, 47, 45, 42, 44, 42, 45, 45, Take 40+41+42 =123 divide by 3 = 41 - 36 handi cap is 5. |
#3
|
|||
|
|||
Try...
=AVERAGE(SMALL(A1:M1,{1,2,3}))-36 Hope this helps! In article , "Mike Busch" wrote: I am doing a Golf outing for my aunt. She has a list of scores across a row and I will need to find the 3 lowest scores and divide the total by 3 and subtract the par for that cousre to come up with their handicape. thank you in advance. Exp. 42, 44, 42. 40, 45, 41, 47, 45, 42, 44, 42, 45, 45, Take 40+41+42 =123 divide by 3 = 41 - 36 handi cap is 5. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |