Thanks again Rick that's perfect
Now I can work out what my son has to do in the last round to win the
championship. (Kill the first two drivers :-))
Steve

"Rick Rothstein (MVP - VB)" wrote in
message ...
Ahh! You wanted the **sum** of the eight highest scores... I did not
understand that to be what you were looking for from your other postings.
I think this single formula (Entered normally) will give you that...

=SUMPRODUCT(LARGE(($B2:$L2<"")*$B2:$L2,{1,2,3,4,5 ,6,7,8}))

You will not need the other formulas I posted... the above should give you
the sum directly.

Rick


"Steve Smyth" wrote in message
...
Thanks Rick that was perfect.
I was hoping I could do it in one formula but that is fine. Just hide the
columns N to U and have =Sum(N2:U2) in column V.
Thanks to both of you, you've been a great help.
PS Typing is a real problem for me and if I didn't go over what I've done
and correct it you would probabley not understand a word.
So sorry again to be so vague.

Steve

"Rick Rothstein (MVP - VB)" wrote in
message ...
Hi Ron I really didn't think this would be such a problem.

There are multiple ways to read your request. While you know what you
want, we don't... so all we have to go on is the completeness of the
description you give us.

Largest 8 scores per person?.-yes
Overall for all competitors?-don't care
Do you want them listed somewhere on the worksheet? - don't understand
Do you need names associated with the top 8 scores?- they have names
How do you want to handle tie scores?- if there is a tie so-be-it
Meanwhile, see the LARGE function in Excel Help- I don't understand it.
I'm sorry to be so vague but I'm a grumpy old man who can't type to
save his life and finds Misrosoft help files a foreign language.

All right, assuming your names are listed in column A and that your
scores are in column B through L and that the first name is on row 2....
I am going to assume you want the 8 highest scores listed in column N
through U within the same row. Put this formula in N2...

=LARGE(($B2:$L2<"")*$B2:$L2,COLUMNS($A:A))

and commit it by pressing Ctrl+Shift+Enter (do **not** just press Enter
by itself). Now, copy N2 across through to U2. That will give you the 8
highest scores (each duplicate score counts individually) for the first
name. Next, select N2:U2 and then copy it down through all your names
(which will give you the 8 highest scores for the rest of the names).

Rick