Assume the scores are in B2:B8 and that the persosn with a score in B5 is
selected
=IF(ISNUMBER(MATCH(B5,SMALL(B2:B8,ROW(INDIRECT("1: 5"))),0)),SUM(SMALL(B2:B8,ROW(INDIRECT("1:5")))),S UM(SMALL(B2:B8,ROW(INDIRECT("1:5"))))+B5)
entered with ctrl + shift & enter
Regards,
Peo Sjoblom
"dobball23" wrote:
I have a list of seven people (golfers) who will have scores. For the
team scoring I would like the top-five of those seven to be
calculated and omit the bottom two scores. I would also like for a
specific one of those golfers to count regardless of their score. Is
there a formula that would do this?
Let me know if I need to explain this better.
A quick recap...
-I have seven golfers
-One of those golfers (preselected) counts in the team score no matter
what
-The two worst scores (outside of the one that counts no matter what)
must be ommitted.
Thanks for the help!
Todd
|