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