SUM formula for lowest or highest numbers in a column

Occasional Visitor
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



Maybe with this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.