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.

=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.

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.