cant create a formula

[mikhal]

Hello there,
i have a list of values in a column, i want to just add up just the highest
4 values.
so for
1; 1; 2; 2 ;2; 3; 5;
i get the value 12..but i cant see to get excel to do this!

 

[SteveG]

Mikhal,

=SUM(LARGE(A1:A7,{1,2,3,4}))

A1:A7 is your values.


Cheers,

Steve

 

[Niek Otten]

=SUM(LARGE(A1:A7,{1;2;3;4})), Array-entered, that is, instead of just ENTER,
hit CTRL+SHIFT+ENTER

 

[Ron Rosenfeld]

Hello there,
i have a list of values in a column, i want to just add up just the highest
4 values.
so for
1; 1; 2; 2 ;2; 3; 5;
i get the value 12..but i cant see to get excel to do this!

where "rng" is the range where your numbers are stored.

=SUM(LARGE(rng,{1,2,3,4}))


--ron

 

[Niek Otten]

Why did I think it needed to be array-entered?

 

[mikhal]

Why did I think it needed to be array-entered?

Many thanks to all your comments!

 

[Ron Rosenfeld]

Why did I think it needed to be array-entered?

Well, it is an array formula. Just happens to be one that you don't need to
array-enter.


--ron

 

[Niek Otten]

(I hope) I'll never stop learning
I'll get back to the books for this
Thanks!