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.
@Quaruple_Pawn, because of the double quotes, your formula was not working but as soon as I removed them, it worked like a charm.
Thank you for the massive help!
Thank you for the massive help!