=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