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.
=SUMPRODUCT(AGGREGATE(15,6,IF(A1:A25>0,A1:A25),{1,2,3,4,5}))
I tried this formula and it seems to work. If you don't work with Office365 or 2021 you have to enter the formula with ctrl+shift+enter.
Hi OliverScheurich
Thank you for the prompt response. I have tried your formula and it shows the #VALUE! error. If i press ctrl+shift+enter, it shows the #NUM! error.
Thank you for the prompt response. I have tried your formula and it shows the #VALUE! error. If i press ctrl+shift+enter, it shows the #NUM! error.
That' s surprising as it works in my spreadsheet.
Can you attach a file of your spreadsheet where i can see the formula you entered and the range of data which you want to sum.