Sum Larget Values

[gsbelbin]

Hi
I have a list of values and I want to sum the largest n of these. Originally I was just summing the largest 3 and used the formula:-​

=SUM(LARGE(A2:A100,{1,2,3}))​

However I'd now like to enter a number in another cell which would then define the number of values to sum. So I need to make the {1,2,3} bit dynamic.​

Can anyone help?​

Cheers​

Gordon​

 

[Sandeep Warrier]

....
ROW(INDIRECT("1:"&C1)) part is doing?
....

INDIRECT returns a range for a text input

So INDIRECT("1:"&C1) ... where C1 houses a number... will return

INDIRECT("1:"&3) => INDIRECT("1:3"), which when wrapped with ROW

ROW(INDIRECT("1:3") => ROW($1:$3)... which returns the array {1;2;3}

 

[gsbelbin]

INDIRECT returns a range for a text input

So INDIRECT("1:"&C1) ... where C1 houses a number... will return

INDIRECT("1:"&3) => INDIRECT("1:3"), which when wrapped with ROW

ROW(INDIRECT("1:3") => ROW($1:$3)... which returns the array {1;2;3}

Thanks, Sandeep. It makes sense now.

Cheers

Gordon