How do I add the top 8 values from a row of 10 entires ?

Mar 1st, 2002, 02:47 AM

Hi,

I am stuck I am trying to add the top 8 alues from this row of 10 entires:-
Answer
19 23 29 17 22 23 20 25 25 24 191

but I am not sure how to do this ?

Aladin Akyurek · Mar 1st, 2002, 03:09 AM

Quote:

On 2002-03-01 01:47, Anonymous wrote:
Hi,

I am stuck I am trying to add the top 8 alues from this row of 10 entires:-
Answer
19 23 29 17 22 23 20 25 25 24 191

but I am not sure how to do this ?

Use one of:

=IF((COUNT(A1:A10)<=B1),SUM(A1:A10),SUM(LARGE(A1:A10,{1,2,3,4,5,6,7,8})))

=IF((COUNT(A1:A10)<=B1),SUM(A1:A10),SUMPRODUCT(LARGE(A1:A10,ROW(INDIRECT("1:"&B1)))))

where B1 holds 8, the desired number of top/largest values.

Bobefax · Mar 1st, 2002, 04:45 AM

I have now registered as a user.

Tried both equations and they work !

Many thanks for you quick response.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 1st, 2002, 02:47 AM	#1
Guest Posts: n/a	Hi, I am stuck I am trying to add the top 8 alues from this row of 10 entires:- Answer 19 23 29 17 22 23 20 25 25 24 191 but I am not sure how to do this ?

Mar 1st, 2002, 04:45 AM	#3
Bobefax New Member Join Date: Feb 2002 Posts: 9	I have now registered as a user. Tried both equations and they work ! Many thanks for you quick response.