Sum top 6 out of 10 data
Author Message
Sum top 6 out of 10 data

I have 10 data in A1:A10 . Now I want to sum the highest/lowest 6 data from
these data. How can I do this in Excel?

Tue, 28 Oct 2003 21:18:39 GMT
Sum top 6 out of 10 data
Mahmud,

To sum the largest values, use

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

To sum the smallest values, use

=SUM(SMALL(A1:A10,{1,2,3,4,5,6}))

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC

Quote:
> I have 10 data in A1:A10 . Now I want to sum the highest/lowest
6 data from
> these data. How can I do this in Excel?

Tue, 28 Oct 2003 21:19:10 GMT
Sum top 6 out of 10 data
GEEEEEEE!

I just used QuickSort algorithms to find the top 10 of my 96 numbers ... Does
anyone else know this trick or I am the only dumbass ....

Quote:
-----Original Message-----

Mahmud,

To sum the largest values, use

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

To sum the smallest values, use

=SUM(SMALL(A1:A10,{1,2,3,4,5,6}))

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC

> I have 10 data in A1:A10 . Now I want to sum the highest/lowest
6 data from
> these data. How can I do this in Excel?

.

Tue, 28 Oct 2003 22:00:04 GMT
Sum top 6 out of 10 data
Just a comment: if you have a large set of numbers, say 9600 instead of 96,
the SMALL and LARGE functions are very slow. A quicker method is to sort the
array in memory then resize to 10 rows.
Quote:

>GEEEEEEE!

>I just used QuickSort algorithms to find the top 10 of my 96 numbers ... Does
>anyone else know this trick or I am the only dumbass ....

>-----Original Message-----
>Mahmud,

>To sum the largest values, use

>=SUM(LARGE(A1:A10,{1,2,3,4,5,6}))

>To sum the smallest values, use

>=SUM(SMALL(A1:A10,{1,2,3,4,5,6}))

Wed, 29 Oct 2003 01:55:45 GMT
Sum top 6 out of 10 data
why not sort it and then autofilter top10 and change it top 6(in top10
autofilter window)  and sum it using sigma. try this in worksheet function
and you an make a code or macaro.

Quote:
> I have 10 data in A1:A10 . Now I want to sum the highest/lowest 6 data
from
> these data. How can I do this in Excel?

Wed, 29 Oct 2003 12:31:46 GMT

 Page 1 of 1 [ 5 post ]

Relevant Pages