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

[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?

 

[John P]

Hi Tas

Checkout =LARGE in help.

That may give you a clue.

John
North Yorkshire UK

 

[Ron Rosenfeld]

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?

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