how do i add an group of numbers then subtract the lowest few?

Copper Contributor

I am looking for a formula to add a bunch of random numbers then subtract the lowest few

1 Reply
Hi Keith,

If you have 10 random numbers in cells A1:A10 then this formula would do it

=SUMIFS( A1:A10, A1:A10,">"&SMALL(A1:A10, 4 ) )

Note the 4 says ignore the 4 lowest values, so you change that as you desire