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.
Remove the double quotes.
- WOW! Such a small fix but it works! Thank you Detlef_Lewin for the help.
- Double quotes around the numbers makes them text. Some functions ignore text (like SMALL()), and some throw an error.
