need help creating formula in excel

[shoo]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I have excel 2004 and need to create a formula that will add together the 4 largest numbers from a group of 15 and disregard the remaining numbers. Can anyone give me an idea how to do this?

 

[Bob Greenblatt]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I have excel 2004 and need to create a formula that will add together the 4
largest numbers from a group of 15 and disregard the remaining numbers. Can
anyone give me an idea how to do this?

Rather than a single formula, why don't you make a copy of the numbers in
another columns? Sort them and sum the first 4.

 

[Niek Otten]

=LARGE(A1:A15,1)+LARGE(A1:A15,2)+LARGE(A1:A15,3)+LARGE(A1:A15,4)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Version: 2004
| Operating System: Mac OS X 10.5 (Leopard)
| Processor: intel
|
| I have excel 2004 and need to create a formula that will add together the 4 largest numbers from a group of 15 and disregard the
remaining numbers. Can anyone give me an idea how to do this?

 

[Carl Witthoft]

=LARGE(A1:A15,1)+LARGE(A1:A15,2)+LARGE(A1:A15,3)+LARGE(A1:A15,4)

That was my thought, too. I'm thinking there's probably an array
formula version that looks something like

=sum(large(A1:a15,{1,2,3,4})

but of course I'm too lazy to work it out.

Carl

 

[Phillip Jones]

well the simplest method if still works in 2008 (did in 2004)

click in the first cell (should be empty where the formula will reside)
then double click on autosum symbol (looks like a fancy Z) then click
click in next cell, then click in next cell (don't drag) when complete
click on autosum again to get out.

Your formula will look roughly like

=Sum(C1+D1=R1=X1)
or
Sum(C1+D1=R1=X1)

If you do a Drag from one position to the other it will look like:

=SUM(A1:X1)
or
SUM(A1:X1)

(which indicates all in sequence from A1 through X1)

That was my thought, too. I'm thinking there's probably an array
formula version that looks something like

=sum(large(A1:a15,{1,2,3,4})

but of course I'm too lazy to work it out.

Carl

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>

 

[Phillip Jones]

Forgot to hit shift when I hit equal sign to make Plus sign formula
contents should be:

=Sum(C1+D1+R1+X1)

or

Sum(C1+D1+R1+X1)

Sorry :-(

well the simplest method if still works in 2008 (did in 2004)

click in the first cell (should be empty where the formula will reside)
then double click on autosum symbol (looks like a fancy Z) then click
click in next cell, then click in next cell (don't drag) when complete
click on autosum again to get out.

Your formula will look roughly like

=Sum(C1+D1=R1=X1)
or
Sum(C1+D1=R1=X1)

If you do a Drag from one position to the other it will look like:

=SUM(A1:X1)
or
SUM(A1:X1)

(which indicates all in sequence from A1 through X1)

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>

 

[CyberTaz]

Sorry, Phillip, but although those options will sum the values in the
specified cells or range, that isn't what the OP was looking for. He needed
a single operation that would examine a specified range of 15 cells and sum
only the 4 largest values in that range.

Regards |:>)
Bob Jones
[MVP] Office:Mac