Thanks Dave...still working on ya suggestion...I accidentally repeated post
due to not seing it come "thro'".
Will feedback to group thanks.
Terry
"Dave Peterson" wrote in message
...
The last response didn't help?????

Terry wrote:

Thank you group, but I may not have described my task correctly.

Please see an actual row of 36 individual scores (B6:AW6) ranging from
5, to
37:

12,15,24,17,10,15,12,7,10,37,18,22,8,10,11,22,24,1 4,18,23,15,9,13,18,29,23,1
8,22,17,21,13,28,22,18,29,5.

Now I need to find the top highest scores and sum them, if a row does
not
contain at least 25 number of scores then text to be "NQ", otherwise
aggregate of top 25 scores.
The formulae suggested gave me an answer in a blank cell at the end of
the
row of 37, but I did it manually and got 517 aggregate. I wonder if I am
entering formulae incorrectly, as I am unable to enter an array using
ctr,shift,enter keys...its the order at which I select these keys?

Regards
Terry

"Sandy Mann" wrote in message
...
Hi JE,

Wouldn't:
=IF(COUNT(A1:A100)<25,"NQ",SUM(LARGE(A1:A100,ROW(1 :25))))

work just as well and stop it being volatile?


--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"JE McGimpsey" wrote in message
...
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):


=IF(COUNT(A1:A100)<25,"NQ",SUM(LARGE(A1:A100,ROW(I NDIRECT("1:25")))))

In article ,
"Terry" wrote:

Win XP Pro
MS-Office XP

I have a workbook with a spredsheet showing bowling scores from
other
sheets in the workbook, with much appreciated help from this NG.

The scores are in ROWS, with up to 50 scores per season.

What I wish to do is automate where In a cell at the end of each
row it
will
show the highest 25 scores per player...If not played 25 games then
text
to
show "NQ" (meaning not qualified).

The highest 25 scores will be in aggregate form and not average.

The actual scores will range from 1 to 40 each game.

The number of rows may be up to 40.

Also on this sheet are columns with date of each match.

Hope I have explained OK?

Regards

Terry



--

Dave Peterson