software

Hi,
I have a range of 10 numbers.
How can I get the sum of the 3 highest numbers in a range?

Hi!

Try this:

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

Biff

quot;Royquot; gt; wrote in message
...
gt; Hi,
gt; I have a range of 10 numbers.
gt; How can I get the sum of the 3 highest numbers in a range?

One way is

=LARGE(B2:B11,1)
=LARGE(B2:B11,2)
=LARGE(B2:B11,3)

put these formulas in A1, A2 and A3. B2:B11 is your 10 numbers you
wish to search.

hope it helps.--
goober
------------------------------------------------------------------------
goober's Profile: www.excelforum.com/member.php...oamp;userid=19838
View this thread: www.excelforum.com/showthread...hreadid=505981YES! in stead of an formula that is huge, I now have this little formula.
BIG THANKS

/Roy

Biff skrev:

gt; Hi!
gt;
gt; Try this:
gt;
gt; =SUM(LARGE(A1:A10,{1,2,3}))
gt;
gt; Biff
gt;
gt; quot;Royquot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt; I have a range of 10 numbers.
gt; gt; How can I get the sum of the 3 highest numbers in a range?
gt;
gt;
gt;

This was helpful. I am doing the same thing but will have ranges that are
not the same.

IE: Looking to sum the top 20 when some have 25#s amp; others have less than 20.

Halp!

quot;Royquot; wrote:

gt; YES! in stead of an formula that is huge, I now have this little formula.
gt; BIG THANKS
gt;
gt; /Roy
gt;
gt; Biff skrev:
gt;
gt; gt; Hi!
gt; gt;
gt; gt; Try this:
gt; gt;
gt; gt; =SUM(LARGE(A1:A10,{1,2,3}))
gt; gt;
gt; gt; Biff
gt; gt;
gt; gt; quot;Royquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Hi,
gt; gt; gt; I have a range of 10 numbers.
gt; gt; gt; How can I get the sum of the 3 highest numbers in a range?
gt; gt;
gt; gt;
gt; gt;

=SUM(LARGE(A1:A100,ROW(INDIRECT(quot;1:quot;amp;MIN(20,COUNT( A1:A100))))))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

quot;SonicBro1quot; gt; wrote in message
...
gt; This was helpful. I am doing the same thing but will have ranges that are
gt; not the same.
gt;
gt; IE: Looking to sum the top 20 when some have 25#s amp; others have less than
20.
gt;
gt; Halp!
gt;
gt; quot;Royquot; wrote:
gt;
gt; gt; YES! in stead of an formula that is huge, I now have this little
formula.
gt; gt; BIG THANKS
gt; gt;
gt; gt; /Roy
gt; gt;
gt; gt; Biff skrev:
gt; gt;
gt; gt; gt; Hi!
gt; gt; gt;
gt; gt; gt; Try this:
gt; gt; gt;
gt; gt; gt; =SUM(LARGE(A1:A10,{1,2,3}))
gt; gt; gt;
gt; gt; gt; Biff
gt; gt; gt;
gt; gt; gt; quot;Royquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; Hi,
gt; gt; gt; gt; I have a range of 10 numbers.
gt; gt; gt; gt; How can I get the sum of the 3 highest numbers in a range?
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;