Formula

[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?

 

[J.E. McGimpsey]

One way:

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

 

[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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Guest]

THANK-YOU! Did exactly what I needed it to do!

-----Original Message-----
One way:

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


.

 

[J.E. McGimpsey]

No need to array enter...

 

[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?
.

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)

 

[Norman Harker]

Thanks JE and Seasons Greetings!

Have you an index for your web site?

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[J.E. McGimpsey]

Have you an index for your web site?

A poor one:

http://www.mcgimpsey.com/excel/index.html

(or just http://mcgimpsey.com/excel/ )

updating that is on the list. After converting Ron's GoogleSearch6
to Mac.

 

[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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.