SUM formula for lowest or highest numbers in a column

Copper Contributor
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 column, how would I total up only the five lowest numbers within that column of 20 assuming they are not listed in any specific order?
1 Reply

@Tcharlton1279 

=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.