G
Guest
Hi,
I have a range of 10 numbers.
How can I get the sum of the 3 highest numbers in a range?
I have a range of 10 numbers.
How can I get the sum of the 3 highest numbers in a range?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Biff
Hi!
Try this:
=SUM(LARGE(A1:A10,{1,2,3}))
Biff
Try this:
=SUM(LARGE(A1:A10,{1,2,3}))
Biff
G
goober
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.
=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.
G
Guest
YES! in stead of an formula that is huge, I now have this little formula.
BIG THANKS
/Roy
Biff skrev:
BIG THANKS
/Roy
Biff skrev:
G
Guest
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 & others have less than 20.
Halp!
not the same.
IE: Looking to sum the top 20 when some have 25#s & others have less than 20.
Halp!
B
Bob Phillips
=SUM(LARGE(A1:A100,ROW(INDIRECT("1:"&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)
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)