Formula

S

Scott

From someone who has little math or computer skills.....

I have a range of six numbers - from those six, I need to
find the 4 largest and then get a total. What formula
will work?
 
N

Norman Harker

Hi Scott:

Try:

=SUM(LARGE(A1:A100,{1,2,3,4}))
Entered as an array by pressing and holding down Ctrl + Shift and then
pressing Enter


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
M

mjr

-----Original Message-----
From someone who has little math or computer skills.....

I have a range of six numbers - from those six, I need to
find the 4 largest and then get a total. What formula
will work?
.
Click to expand...
assuming the numbers are in cells a1 to a6 i would sum all
less the 5th and 6th largest;

=SUM(A1:A6)-LARGE(A1:A6,5)-LARGE(A1:A6,6)
 
N

Norman Harker

Thanks JE and Seasons Greetings!

Have you an index for your web site?

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
N

Norman Harker

Hi JE!

Thanks. One for my list of references.

I'm busy on the User Guide for Ron's Google Search 6

He keeps us busy; slave driver!!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top