Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |