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
|