Forum Discussion
SUM formula for lowest or highest numbers in a column
Hello, I'm hoping someone can help guide me in this formula. How would I go about creating a formula that totals up a certain amount of numbers within a column? For example if I have 20 numbers in a c...
=SUM(SMALL(C1:C20,{1,2,3,4,5}))Maybe with this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.