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
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)))
Anonymous's avatar
Anonymous
May 13, 2019

Thank you will give it a tryTwifoo 

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    May 13, 2019
    Please do try it and update me thereafter.