Forum Discussion
Solved
Excel limit number of item in sum
Is it possible to limit the number of items in a sum to the first 10 that are over a certain value. For example if there are 50 cells with values ranging from 0 to 40, can I include a formula to ...
=SUM(SMALL(IF(A1:E10>20,A1:E10),{1,2,3,4,5,6,7,8,9,10}))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
=SUM(SMALL(IF(A1:E10>20,A1:E10),{1,2,3,4,5,6,7,8,9,10}))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
Fantastic works perfectly 🙂
