Forum Discussion

ianshaw2's avatar
ianshaw2
Copper Contributor
Sep 24, 2022
Solved

Rows of numbers selection and addition

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...
  • Riny_van_Eekelen's avatar
    Sep 24, 2022

    ianshaw2 Perhaps something like this?

     

     

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