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

[Guest]

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]

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]

I have now registered as a user.

Tried both equations and they work !

Many thanks for you quick response.