Thread: Best 4 scores
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Nigel Greenwood
 
Posts: n/a
Default Best 4 scores


Bob Phillips wrote:
The try this

=SUM(LARGE(A1:A10,ROW(INDIRECT("1:"&MIN(4,COUNT(A1 :A10))))))

and this really is an array formula.


Thanks, Bob -- just what I was looking for. All these years, & I'm
still learning how to use Excel!

Nigel