How do I add 12 out of 18 numbers without using sort to get them .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The list are scores that need to be kept in order. I need to be able to add
the best 12 numbers to provide a score at the end of the year.

Can anyone help?
 
The list are scores that need to be kept in order. I need to be able to add
the best 12 numbers to provide a score at the end of the year.

Can anyone help?
Click to expand...

Depending on whether "best" is the highest or lowest:

=SUM(LARGE(scores,ROW(INDIRECT("1:12"))))

entered as an array formula. To enter and array formula, after typing or
pasting the formula into the formula bar, hold down <ctrl><shift> while hitting
<enter>. XL will place braces {...} around the formula.


--ron
 
Back
Top