Forum Discussion
KEITH FERRY
Jul 17, 2018Copper Contributor
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
Wyn Hopkins
Jul 24, 2018MVP
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
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