PC Review


Reply
Thread Tools Rate Thread

Adding the max 8 values in a list

 
 
Ken Guest
Guest
Posts: n/a
 
      3rd Apr 2008
Hi there
I have a list of numbers that can be 80 numbers long in any order (they
could consist of only 1's, 2's or 3's). I need to add the highest 8 numbers
together. Is there a simple way to do this??
eg

1 1 0 1 2 2 0 3 3 0 3 3 3

Now I need it to give me a total of 20 (all the 3's, 2's and one 1)
 
Reply With Quote
 
 
 
 
Gary''s Student
Guest
Posts: n/a
 
      3rd Apr 2008
=SUM(LARGE(A1:M1,{1,2,3,4,5,6,7,8}))


--
Gary''s Student - gsnu200777
 
Reply With Quote
 
Ken Guest
Guest
Posts: n/a
 
      3rd Apr 2008
THANKS----Seems to be working exactly as I want it.

"Gary''s Student" wrote:

> =SUM(LARGE(A1:M1,{1,2,3,4,5,6,7,8}))
>
>
> --
> Gary''s Student - gsnu200777

 
Reply With Quote
 
Gary''s Student
Guest
Posts: n/a
 
      3rd Apr 2008
If you have any problems using or adapting the formula, update this post..
--
Gary''s Student - gsnu200777


"Ken Guest" wrote:

> THANKS----Seems to be working exactly as I want it.
>
> "Gary''s Student" wrote:
>
> > =SUM(LARGE(A1:M1,{1,2,3,4,5,6,7,8}))
> >
> >
> > --
> > Gary''s Student - gsnu200777

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
javascript: adding values to list box ranjini ns Microsoft C# .NET 4 10th Jun 2008 06:51 PM
Adding values from a List Box =?Utf-8?B?R2F0b3I=?= Microsoft Access Forms 8 10th Aug 2007 10:02 PM
Adding values in a list box =?Utf-8?B?RG9u?= Microsoft Access Form Coding 2 15th Jan 2006 02:17 AM
adding values from a list =?Utf-8?B?R2F0b3I=?= Microsoft Access Forms 1 28th Apr 2005 09:56 AM
adding new values the value list in a combo box Anthony Microsoft Access Forms 4 19th Jan 2004 02:11 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:45 AM.