Forum Discussion

Anonymous's avatar
Anonymous
May 07, 2019

adding up cells

I have a column of 6 cells that I want to sum up the top 4 in value. How can this be done?

 

excel

4 Replies

  • PeterBartholomew1's avatar
    PeterBartholomew1
    Silver Contributor
    May 13, 2019

    Since I currently on the Office 365 machine

    = SUM( LARGE( values, SEQUENCE(4) ) )

    = SUMIFS( values, values, ">="&LARGE(values,4) )

    = SUM( FILTER( values, values>=LARGE(values,4)) )

    add a bit of variety. Despite the choice, I think I will go with the first to avoid problems with tied 4th places.

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    May 07, 2019
    If the cells you want to sum are in A2:A7, you may use this formula to get the sum of the top 4:
    =SUMPRODUCT(LARGE(A2:A7,ROW(1:4)))