I have not explained my "case" very well, so I will try in more detail:
The bowls drives cover about 7 months (twice a week).

At season end there is a "play off" with the top 4 highest (combined) scores
from the spreadsheet, currently the highest aggregate is the one taken into
account, but committee wish to have it as outlined below.

To qualify for the play off's they have to play a minimum of 25 drives.
Once the 25 drives are reached, ONLY their highest 25 drive scores will
count and summed after that.

My spreadsheet has all NAMES in the leftmost column(A4:A50).
Their scores go in rows (B4:AW50), with the days heading shown in rows
(B3:AW3)
Their total drives played are in shown in Columns (AX4:AX50).

Now I need a formula/function to look at each players drives
total(AX4:AX50),to see if they have reached the qualifying 25 drives
played....if not then "unqualified".
Now if they have reached 25 or more drives, then find the highest 25 drive
scores and sum them.
I hope then to RANK them by highest to lowest.

I do hope I have explained better (novice really)...I am not obtaining the
result hoped for with suggested formulae so far, but it may be me.?

Terry

"Sandy Mann" wrote in message
...
mmmm.....

I gor #NUM! errors when I had blank cells so I added the +0 but I don't??

I didn't realise that you would be dragging the formula down, I thought
that you just wanted the sum of the largest 25 scores. Try making the
ranges absolute:

=IF(COUNT($H$1:$H$150)<25,"Not
Qualified",SUM(LARGE($H$1:$H$50,ROW($A$1:$A$25))))

Still array entering it.

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Terry" wrote in message
...
Thank you Sandy.
#NUM! errors.
The last part of your formula is (1:25) for my first row, then it goes:
2:26(row 2), 3:27(row 3) and repeats this pattern, when it gets to the
#NUM! error that cell shows 45:49(row 45).
I must be entering wrong, but I did enter first cell as an array and
copied cells down??

Terry


"Sandy Mann" wrote in message
...
=IF(COUNT(H1:H150)<25,"Not Qualified",SUM(LARGE(H1:H50+0,ROW(1:25))))

Entered as an array formula by holding down the Ctrl and Shift keys
while you press Enter.

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Terry" wrote in message
...
One new cell summing the BEST 25 scores.(some players will not have
played 25 drives, so they will not come into the equation).

Terry

"Tyro" wrote in message
et...
What do you mean by "flag"? Format the cells in a certain color? Or
what?

Tyro

"Terry" wrote in message
...
Hi group

Win XP
MS Office 2003

I use a spreadsheet to record players bowls drives scores, and wish
to flag up the best 25 scores for each player, from the row of
scores.
I.E.
A4(name), B19:AW12(row of scores), AX4(player's total played games)..
The individual scores will range from zero to around 40 each drive.

TIA

Terry