Dynamic Sum function with filter

[Delimaster]

I'm trying to come up with a function that will let me search remaining values, filter them from small to largest, and then sum them based on a count reference in another cell.

I can get everything laid out, but i'm not sure how to only sum a range based on another cell value, and exclude blanks.

Any help?

 

[Delimaster]

This is getting closer, the only issue now is that it removes the duplicates, haha. Basically the inverse of the previous problem. Instead of the list saying:

21,
21,
30,
30,
etc...

It list,
21,
30,
59,
etc..

Thank you very much for the effort so far. Always nice to know I have a lot to learn!

 

[Benders]

I may have nailed it finally. Assuming you named M1:M50 as BlanksRange and N1:N50 as NoBlanksRange enter the formula below and again use CTRL+SHIFT+ENTER and drag down

=IF(ROW()-ROW(NoBlanksRange)+1>ROWS(BlanksRange) - COUNTBLANK(BlanksRange),"",INDIRECT(ADDRESS(SMALL((IF(BlanksRange<>"",ROW(BlanksRange),ROW()+ROWS(BlanksRange))),ROW()-ROW(NoBlanksRange)+1),COLUMN(BlanksRange),4)))

Or you could use

=IFERROR(INDEX(BlanksRange,SMALL((IF(LEN(BlanksRange),ROW(INDIRECT("1:"&ROWS(BlanksRange))))),ROW(A7)),1),"")
again use CTRL+SHIFT+ENTER and drag down

 

[Delimaster]

Apparently, I'm too stupid to figure out how to copy and paste this thing, because it errors out when I try and correct the ranges.

Can I send you the excel file to play with?