I have a column of 6 cells that I want to sum up the top 4 in value. How can this be done?
Thank you will give it a try@Twifoo
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.