Summation of 3 biggest numbers...

hi all, is there any quick method to add up 3 biggest numbers in a set 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!

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

=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 :-)
------------------------------*------------------------------*----------------


"lau0001" <[email protected]> wrote in
message news:[email protected]...
>
> hi all, is there any quick method to add up 3 biggest numbers in a set
> 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
> ------------------------------------------------------------------------
> lau0001's Profile:
> http://www.excelforum.com/member.php...o&userid=33320
> View this thread: http://www.excelforum.com/showthread...hreadid=531442
>

On Mon, 10 Apr 2006 16:30:42 +0100, "Ken Wright"
<[email protected]> wrote:

>=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
--
Email (ROT13)
[email protected]

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

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

"Nozza" <[email protected]> wrote in message
news:[email protected]...
> On Mon, 10 Apr 2006 16:30:42 +0100, "Ken Wright"
> <[email protected]> wrote:
>
>>=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
> --
> Email (ROT13)
> [email protected]