Forum Discussion

Deleted's avatar
Deleted
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)))
  • Deleted's avatar
    Deleted
    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.