Forum Discussion

Tcharlton1279's avatar
Tcharlton1279
Copper Contributor
Apr 05, 2022

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 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?
excel

1 Reply

  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Apr 05, 2022

    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. 

Resources