Formula Question?

[ellswj]

Hi Everyone,
This is my first timeposting on here. I have a Question, I'm run a poker league, and to keep track of the points I'm using excel. My problem is We add up the top 7 out of 10 events and for the life of me I cannot figure out how to do this. any help on this subject would be greatly appreciated. Thank you,

Jarrad Ellsworth

 

[Tazguy37]

Welcome to MrExcel Board!

Try something like this:

=SUM(LARGE(B2:B11,{1,2,3,4,5,6,7}))

Where B2:B11 is the range of point values; adjust if neccesary. Hope that helps!