Rows of numbers selection and addition

New 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 (New Contributor)

@ianshaw2 Perhaps something like this?






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