Summation of 3 biggest numbers...

[lau0001]

hi all, is there any quick method to add up 3 biggest numbers in a se
of number? e.g.
I have the following data in a row:

100 20 90 30

And I want to add up 3 biggest numbers, i.e.
100 + 90 + 30 = 220

Thanks

 

[lau0001]

thanks all, I have solved the problem by "large" function.

 

[Ken Wright]

=SUMPRODUCT(LARGE(A1:Z1,{1,2,3}))

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[Nozza]

=SUMPRODUCT(LARGE(A1:Z1,{1,2,3}))

Hi Ken

Thanks for this - this is really useful stuff.

Been having a look into this and am now wondering why you chose to use
SUMPRODUCT instead of SUM?

I've tried SUM and get the same results. Or is that by chance?

Thanks

Noz

 

[Ken Wright]

Nope, my bad - I just get so used to using SUMPRODUCT that I'll occasionally
miss the simpler option :-(

Regards
Ken................