Forum Discussion

KEITH FERRY's avatar
KEITH FERRY
Copper Contributor
Jul 17, 2018

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

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

Resources