cant create a formula

M

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!
 
N

Niek Otten

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

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!
Click to expand...

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

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


--ron
 
Top