Selecting Max Values

[dave182]

I'm trying to create a formula that searches through a row and selects certain values. I have a list of individuals in rows followed by their 18 scores in columns. What I'm trying to do is only select the best 8 of those scores and add them together. I tried a few things but this is a little over my head.

Thanks,
Dave

[zbor]

Also, after renaming title upload some example workbook that better describe your problem.

[dave182]

Sorry about the title thing. I attached the file. Any help would be appricated

Thanks

[dave182]

I used

=Large(RANGE,1)+LARGE(RANGE,2)+...

all the up too 8.

[zbor]

you can try this:

=SUM(LARGE(range,ROW(A1:A8)))

comfirmed with ctrl+shift+enter

[shg]

In V2 and copy down, =SUM(LARGE(B2:U2, {1,2,3,4,5,6,7,8} ) )