adding up cells

Deleted
Not applicable

I have a column of 6 cells that I want to sum up the top 4 in value. How can this be done?

 

4 Replies
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)))

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.

Please do try it and update me thereafter.