View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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