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