Need help with a function I'm not sure exists

[Cervantes]

I want excel to sum the highest 5 numbers in a row of 20-25. This means it'll first need to find 5 highest values and then add 'm up.

Example:

1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20 would be 20+19+18+17+16 = 90

Does excel allow for an easy way to do this automatically, or do I have to do this manually?

Thanks in advance

[duane]

for the five highest in row 1 (columns a:z)

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

entered with control+shift+enter

[Cervantes]

for the five highest in row 1 (columns a:z)

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

entered with control+shift+enter

hm, I get some kind of error message, saying the formula has an error. The cursor is on z1 after the error message...

[duane]

the formula works fine for me as long as i have data in that range

[Cervantes]

I think my dutch excel doesn't understand the english terms, so I'm gonna have another look in the help file. But thanks cause you helped look in the right direction.

[Aladin Akyurek]

Just enter will do.

duane wrote:
> for the five highest in row 1 (columns a:z)
>
> =SUM(LARGE(A1:Z1,{1,2,3,4,5}))
>
> entered with control+shift+enter
>
>

[Bob Phillips]

Cervantes,

Try

=SOM(GROOTSTE(A1:Z1;{1;2;3;4;5}))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cervantes" <[email protected]> wrote
in message news:[email protected]...
>
> I think my dutch excel doesn't understand the english terms, so I'm
> gonna have another look in the help file. But thanks cause you helped
> look in the right direction.
>
>
> --
> Cervantes
> ------------------------------------------------------------------------
> Cervantes's Profile:
http://www.excelforum.com/member.php...o&userid=26323
> View this thread: http://www.excelforum.com/showthread...hreadid=395944
>

[Cervantes]

Cervantes,

Try

=SOM(GROOTSTE(A1:Z1;{1;2;3;4;5}))


--

HTH

RP
[/color]

yeah, that's it, thanks. stupid dutch version, i don't know why i have it on my system

[Aladin Akyurek]

Just enter will do.

duane wrote:
> for the five highest in row 1 (columns a:z)
>
> =SUM(LARGE(A1:Z1,{1,2,3,4,5}))
>
> entered with control+shift+enter
>
>

[Bob Phillips]

Cervantes,

Try

=SOM(GROOTSTE(A1:Z1;{1;2;3;4;5}))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cervantes" <[email protected]> wrote
in message news:[email protected]...
>
> I think my dutch excel doesn't understand the english terms, so I'm
> gonna have another look in the help file. But thanks cause you helped
> look in the right direction.
>
>
> --
> Cervantes
> ------------------------------------------------------------------------
> Cervantes's Profile:
http://www.excelforum.com/member.php...o&userid=26323
> View this thread: http://www.excelforum.com/showthread...hreadid=395944
>

[Bob Phillips]

Cervantes,

Try

=SOM(GROOTSTE(A1:Z1;{1;2;3;4;5}))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cervantes" <[email protected]> wrote
in message news:[email protected]...
>
> I think my dutch excel doesn't understand the english terms, so I'm
> gonna have another look in the help file. But thanks cause you helped
> look in the right direction.
>
>
> --
> Cervantes
> ------------------------------------------------------------------------
> Cervantes's Profile:
http://www.excelforum.com/member.php...o&userid=26323
> View this thread: http://www.excelforum.com/showthread...hreadid=395944
>

[Aladin Akyurek]

Just enter will do.

duane wrote:
> for the five highest in row 1 (columns a:z)
>
> =SUM(LARGE(A1:Z1,{1,2,3,4,5}))
>
> entered with control+shift+enter
>
>

[Aladin Akyurek]

Just enter will do.

duane wrote:
> for the five highest in row 1 (columns a:z)
>
> =SUM(LARGE(A1:Z1,{1,2,3,4,5}))
>
> entered with control+shift+enter
>
>

[Bob Phillips]

Cervantes,

Try

=SOM(GROOTSTE(A1:Z1;{1;2;3;4;5}))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cervantes" <[email protected]> wrote
in message news:[email protected]...
>
> I think my dutch excel doesn't understand the english terms, so I'm
> gonna have another look in the help file. But thanks cause you helped
> look in the right direction.
>
>
> --
> Cervantes
> ------------------------------------------------------------------------
> Cervantes's Profile:
http://www.excelforum.com/member.php...o&userid=26323
> View this thread: http://www.excelforum.com/showthread...hreadid=395944
>

[Aladin Akyurek]

Just enter will do.

duane wrote:
> for the five highest in row 1 (columns a:z)
>
> =SUM(LARGE(A1:Z1,{1,2,3,4,5}))
>
> entered with control+shift+enter
>
>

[Bob Phillips]

Cervantes,

Try

=SOM(GROOTSTE(A1:Z1;{1;2;3;4;5}))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cervantes" <[email protected]> wrote
in message news:[email protected]...
>
> I think my dutch excel doesn't understand the english terms, so I'm
> gonna have another look in the help file. But thanks cause you helped
> look in the right direction.
>
>
> --
> Cervantes
> ------------------------------------------------------------------------
> Cervantes's Profile:
http://www.excelforum.com/member.php...o&userid=26323
> View this thread: http://www.excelforum.com/showthread...hreadid=395944
>

[Bob Phillips]

Cervantes,

Try

=SOM(GROOTSTE(A1:Z1;{1;2;3;4;5}))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cervantes" <[email protected]> wrote
in message news:[email protected]...
>
> I think my dutch excel doesn't understand the english terms, so I'm
> gonna have another look in the help file. But thanks cause you helped
> look in the right direction.
>
>
> --
> Cervantes
> ------------------------------------------------------------------------
> Cervantes's Profile:
http://www.excelforum.com/member.php...o&userid=26323
> View this thread: http://www.excelforum.com/showthread...hreadid=395944
>

[Aladin Akyurek]

Just enter will do.

duane wrote:
> for the five highest in row 1 (columns a:z)
>
> =SUM(LARGE(A1:Z1,{1,2,3,4,5}))
>
> entered with control+shift+enter
>
>

[Bob Phillips]

Cervantes,

Try

=SOM(GROOTSTE(A1:Z1;{1;2;3;4;5}))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cervantes" <[email protected]> wrote
in message news:[email protected]...
>
> I think my dutch excel doesn't understand the english terms, so I'm
> gonna have another look in the help file. But thanks cause you helped
> look in the right direction.
>
>
> --
> Cervantes
> ------------------------------------------------------------------------
> Cervantes's Profile:
http://www.excelforum.com/member.php...o&userid=26323
> View this thread: http://www.excelforum.com/showthread...hreadid=395944
>

[Aladin Akyurek]

Just enter will do.

duane wrote:
> for the five highest in row 1 (columns a:z)
>
> =SUM(LARGE(A1:Z1,{1,2,3,4,5}))
>
> entered with control+shift+enter
>
>

[Bob Phillips]

Cervantes,

Try

=SOM(GROOTSTE(A1:Z1;{1;2;3;4;5}))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cervantes" <[email protected]> wrote
in message news:[email protected]...
>
> I think my dutch excel doesn't understand the english terms, so I'm
> gonna have another look in the help file. But thanks cause you helped
> look in the right direction.
>
>
> --
> Cervantes
> ------------------------------------------------------------------------
> Cervantes's Profile:
http://www.excelforum.com/member.php...o&userid=26323
> View this thread: http://www.excelforum.com/showthread...hreadid=395944
>

[Aladin Akyurek]

Just enter will do.

duane wrote:
> for the five highest in row 1 (columns a:z)
>
> =SUM(LARGE(A1:Z1,{1,2,3,4,5}))
>
> entered with control+shift+enter
>
>

[Aladin Akyurek]

Just enter will do.

duane wrote:
> for the five highest in row 1 (columns a:z)
>
> =SUM(LARGE(A1:Z1,{1,2,3,4,5}))
>
> entered with control+shift+enter
>
>

[Bob Phillips]

Cervantes,

Try

=SOM(GROOTSTE(A1:Z1;{1;2;3;4;5}))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cervantes" <[email protected]> wrote
in message news:[email protected]...
>
> I think my dutch excel doesn't understand the english terms, so I'm
> gonna have another look in the help file. But thanks cause you helped
> look in the right direction.
>
>
> --
> Cervantes
> ------------------------------------------------------------------------
> Cervantes's Profile:
http://www.excelforum.com/member.php...o&userid=26323
> View this thread: http://www.excelforum.com/showthread...hreadid=395944
>

[Aladin Akyurek]

Just enter will do.

duane wrote:
> for the five highest in row 1 (columns a:z)
>
> =SUM(LARGE(A1:Z1,{1,2,3,4,5}))
>
> entered with control+shift+enter
>
>

[Bob Phillips]

Cervantes,

Try

=SOM(GROOTSTE(A1:Z1;{1;2;3;4;5}))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cervantes" <[email protected]> wrote
in message news:[email protected]...
>
> I think my dutch excel doesn't understand the english terms, so I'm
> gonna have another look in the help file. But thanks cause you helped
> look in the right direction.
>
>
> --
> Cervantes
> ------------------------------------------------------------------------
> Cervantes's Profile:
http://www.excelforum.com/member.php...o&userid=26323
> View this thread: http://www.excelforum.com/showthread...hreadid=395944
>

[Bob Phillips]

Cervantes,

Try

=SOM(GROOTSTE(A1:Z1;{1;2;3;4;5}))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cervantes" <[email protected]> wrote
in message news:[email protected]...
>
> I think my dutch excel doesn't understand the english terms, so I'm
> gonna have another look in the help file. But thanks cause you helped
> look in the right direction.
>
>
> --
> Cervantes
> ------------------------------------------------------------------------
> Cervantes's Profile:
http://www.excelforum.com/member.php...o&userid=26323
> View this thread: http://www.excelforum.com/showthread...hreadid=395944
>

[Aladin Akyurek]

Just enter will do.

duane wrote:
> for the five highest in row 1 (columns a:z)
>
> =SUM(LARGE(A1:Z1,{1,2,3,4,5}))
>
> entered with control+shift+enter
>
>

[Bob Phillips]

Cervantes,

Try

=SOM(GROOTSTE(A1:Z1;{1;2;3;4;5}))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cervantes" <[email protected]> wrote
in message news:[email protected]...
>
> I think my dutch excel doesn't understand the english terms, so I'm
> gonna have another look in the help file. But thanks cause you helped
> look in the right direction.
>
>
> --
> Cervantes
> ------------------------------------------------------------------------
> Cervantes's Profile:
http://www.excelforum.com/member.php...o&userid=26323
> View this thread: http://www.excelforum.com/showthread...hreadid=395944
>

[Aladin Akyurek]

Just enter will do.

duane wrote:
> for the five highest in row 1 (columns a:z)
>
> =SUM(LARGE(A1:Z1,{1,2,3,4,5}))
>
> entered with control+shift+enter
>
>

[Aladin Akyurek]

Just enter will do.

duane wrote:
> for the five highest in row 1 (columns a:z)
>
> =SUM(LARGE(A1:Z1,{1,2,3,4,5}))
>
> entered with control+shift+enter
>
>

[Bob Phillips]

Cervantes,

Try

=SOM(GROOTSTE(A1:Z1;{1;2;3;4;5}))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cervantes" <[email protected]> wrote
in message news:[email protected]...
>
> I think my dutch excel doesn't understand the english terms, so I'm
> gonna have another look in the help file. But thanks cause you helped
> look in the right direction.
>
>
> --
> Cervantes
> ------------------------------------------------------------------------
> Cervantes's Profile:
http://www.excelforum.com/member.php...o&userid=26323
> View this thread: http://www.excelforum.com/showthread...hreadid=395944
>

[Bob Phillips]

Cervantes,

Try

=SOM(GROOTSTE(A1:Z1;{1;2;3;4;5}))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cervantes" <[email protected]> wrote
in message news:[email protected]...
>
> I think my dutch excel doesn't understand the english terms, so I'm
> gonna have another look in the help file. But thanks cause you helped
> look in the right direction.
>
>
> --
> Cervantes
> ------------------------------------------------------------------------
> Cervantes's Profile:
http://www.excelforum.com/member.php...o&userid=26323
> View this thread: http://www.excelforum.com/showthread...hreadid=395944
>

[Aladin Akyurek]

Just enter will do.

duane wrote:
> for the five highest in row 1 (columns a:z)
>
> =SUM(LARGE(A1:Z1,{1,2,3,4,5}))
>
> entered with control+shift+enter
>
>

[Aladin Akyurek]

Just enter will do.

duane wrote:
> for the five highest in row 1 (columns a:z)
>
> =SUM(LARGE(A1:Z1,{1,2,3,4,5}))
>
> entered with control+shift+enter
>
>

[Bob Phillips]

Cervantes,

Try

=SOM(GROOTSTE(A1:Z1;{1;2;3;4;5}))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cervantes" <[email protected]> wrote
in message news:[email protected]...
>
> I think my dutch excel doesn't understand the english terms, so I'm
> gonna have another look in the help file. But thanks cause you helped
> look in the right direction.
>
>
> --
> Cervantes
> ------------------------------------------------------------------------
> Cervantes's Profile:
http://www.excelforum.com/member.php...o&userid=26323
> View this thread: http://www.excelforum.com/showthread...hreadid=395944
>

[Aladin Akyurek]

Just enter will do.

duane wrote:
> for the five highest in row 1 (columns a:z)
>
> =SUM(LARGE(A1:Z1,{1,2,3,4,5}))
>
> entered with control+shift+enter
>
>

[Bob Phillips]

Cervantes,

Try

=SOM(GROOTSTE(A1:Z1;{1;2;3;4;5}))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cervantes" <[email protected]> wrote
in message news:[email protected]...
>
> I think my dutch excel doesn't understand the english terms, so I'm
> gonna have another look in the help file. But thanks cause you helped
> look in the right direction.
>
>
> --
> Cervantes
> ------------------------------------------------------------------------
> Cervantes's Profile:
http://www.excelforum.com/member.php...o&userid=26323
> View this thread: http://www.excelforum.com/showthread...hreadid=395944
>

[Bob Phillips]

Cervantes,

Try

=SOM(GROOTSTE(A1:Z1;{1;2;3;4;5}))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cervantes" <[email protected]> wrote
in message news:[email protected]...
>
> I think my dutch excel doesn't understand the english terms, so I'm
> gonna have another look in the help file. But thanks cause you helped
> look in the right direction.
>
>
> --
> Cervantes
> ------------------------------------------------------------------------
> Cervantes's Profile:
http://www.excelforum.com/member.php...o&userid=26323
> View this thread: http://www.excelforum.com/showthread...hreadid=395944
>

[Aladin Akyurek]

Just enter will do.

duane wrote:
> for the five highest in row 1 (columns a:z)
>
> =SUM(LARGE(A1:Z1,{1,2,3,4,5}))
>
> entered with control+shift+enter
>
>

[Bob Phillips]

Cervantes,

Try

=SOM(GROOTSTE(A1:Z1;{1;2;3;4;5}))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cervantes" <[email protected]> wrote
in message news:[email protected]...
>
> I think my dutch excel doesn't understand the english terms, so I'm
> gonna have another look in the help file. But thanks cause you helped
> look in the right direction.
>
>
> --
> Cervantes
> ------------------------------------------------------------------------
> Cervantes's Profile:
http://www.excelforum.com/member.php...o&userid=26323
> View this thread: http://www.excelforum.com/showthread...hreadid=395944
>

[Aladin Akyurek]

Just enter will do.

duane wrote:
> for the five highest in row 1 (columns a:z)
>
> =SUM(LARGE(A1:Z1,{1,2,3,4,5}))
>
> entered with control+shift+enter
>
>

[Aladin Akyurek]

Just enter will do.

duane wrote:
> for the five highest in row 1 (columns a:z)
>
> =SUM(LARGE(A1:Z1,{1,2,3,4,5}))
>
> entered with control+shift+enter
>
>

[Bob Phillips]

Cervantes,

Try

=SOM(GROOTSTE(A1:Z1;{1;2;3;4;5}))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cervantes" <[email protected]> wrote
in message news:[email protected]...
>
> I think my dutch excel doesn't understand the english terms, so I'm
> gonna have another look in the help file. But thanks cause you helped
> look in the right direction.
>
>
> --
> Cervantes
> ------------------------------------------------------------------------
> Cervantes's Profile:
http://www.excelforum.com/member.php...o&userid=26323
> View this thread: http://www.excelforum.com/showthread...hreadid=395944
>

[Aladin Akyurek]

Just enter will do.

duane wrote:
> for the five highest in row 1 (columns a:z)
>
> =SUM(LARGE(A1:Z1,{1,2,3,4,5}))
>
> entered with control+shift+enter
>
>

[Bob Phillips]

Cervantes,

Try

=SOM(GROOTSTE(A1:Z1;{1;2;3;4;5}))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cervantes" <[email protected]> wrote
in message news:[email protected]...
>
> I think my dutch excel doesn't understand the english terms, so I'm
> gonna have another look in the help file. But thanks cause you helped
> look in the right direction.
>
>
> --
> Cervantes
> ------------------------------------------------------------------------
> Cervantes's Profile:
http://www.excelforum.com/member.php...o&userid=26323
> View this thread: http://www.excelforum.com/showthread...hreadid=395944
>