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
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.