Re: Simplify formulas

One way:

=SUM(LARGE(A1:A1000,ROW(INDIRECT("1:500"))))

This must be array-entered (CTRL-SHIFT-ENTER or CMD-RETURN).



In article <uxy1QC6jFHA.708@xxxxxxxxxxxxxxxxxxxx>,
"0-0 Wai Wai ^-^" <x@xxxxx> wrote:

> I would like to simplify the following formulas
> =SUM( LARGE(A1:A1000,{1,2,3...500}) )
>
> Is it possible to simplify "{1,2,3...500}"?
> Currently I need to type each number manually by myself, ie 1,2,3,4,5,6,7,8,9
> and so on which is time-consuming.
> Is there any expression which tells the computer that it's "from 1 to 500"?
.

Loading