stuver welcome to the forum. Thank you for uploading an Excel file. It helps.
Try array entering this formula in D24 and filling down until you get blanks. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
Formula:
=IFERROR(INDEX($D$3:$D$13,MATCH(SMALL(IF((SUMIFS($E$3:$E$13,$D$3:$D$13,$D$3:$D$13)>=$C$23)*
(MATCH($D$3:$D$13&"",$D$3:$D$13&"",0)=ROW($D$3:$D$13)-MIN(ROW($D$3:$D$13))+1),
COUNTIF($D$3:$D$13,"<="&$D$3:$D$13)),ROWS($24:24)),COUNTIF($D$3:$D$13,"<="&$D$3:$D$13),0)),"")
Then this slight change to the formula you had in E24 and filled down.
Formula:
=IF(D24="","",SUMIF($D$3:$D$13,"*"&D24&"*",$E$3:$E$13))
Then for amounts <200 this array formula in E23.
Formula:
=SUM(IF(SUMIFS($E$3:$E$13,$D$3:$D$13,$D$3:$D$13)<$C$23,SUMIFS($E$3:$E$13,$D$3:$D$13,$D$3:$D$13)))
Bookmarks