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  
 
 [ 5 post ] 

 Relevant Pages 

1. Sum Top 5% and Top 10%

2. Select Top 10 returns 13, as does Top 5, Top 1

3. Top 10 query: only shows 10 values

4. Numbering the values in a Top 10 Query from 1 to 10

5. Numbering the values in a Top 10 query from 1 to 10

6. Change Top 10 to Top 15 on Autofilter?

7. Pull top 10 from top 15 ind

8. Top 10 from Top 50

9. Top 10 data from an array

10. Top 10 organising and data reference


 
Powered by phpBB® Forum Software © phpBB Group