Forum Discussion
Solved
Finding the 5 least numbers from cells with formulas
Hi everyone, I have the following challenge: I am trying to get the smallest 5 numbers to be summed up from an array of cells. The challenge is that when I use formulas such as SUMPRODUCT or SMAL...
- Remove the double quotes.
Depends what you'd like to sum. For such sample
if small 5 from and you are on Excel 365 or 2021 it could be
=SUM( SMALL( FILTER( G7:G17, G7:G17), SEQUENCE(5)) )If next column, it shall be calculated as numbers, not texts
=LOOKUP( G7, {0,1,45,50,55,60,65,70,75,80}, {0,9,8,7,6,5,4,3,2,1})