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