SOLVED

Rows of numbers selection and addition

Copper Contributor

Hi There

I have a row of 20 to 30  different numbers and need to select the highest ten and total the result of the highest 10 at the start of the row.  I am not even sure if this can be done so any advice is very much appreciated.

2 Replies
best response confirmed by ianshaw2 (Copper Contributor)
Solution

@ianshaw2 Perhaps something like this?

 

Riny_van_Eekelen_0-1664006287532.png

 

=SUMIF(B1:AE1,">="&LARGE(B1:AE1,10))

 

your are a bloody excel genius!!! - thank you so much for your help
1 best response

Accepted Solutions
best response confirmed by ianshaw2 (Copper Contributor)
Solution

@ianshaw2 Perhaps something like this?

 

Riny_van_Eekelen_0-1664006287532.png

 

=SUMIF(B1:AE1,">="&LARGE(B1:AE1,10))

 

View solution in original post