May 07 2019 01:07 PM
May 07 2019 01:07 PM
I have a column of 6 cells that I want to sum up the top 4 in value. How can this be done?
May 07 2019 01:18 PM
May 13 2019 03:54 PM - edited May 13 2019 03:55 PM
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.