Hello again,
Sorry I thought my formula was doing something it wasn't. Wrap the formulas in your "Eligible" column in ROUND(--formula---,0) and use the formula below in g14
=IFERROR(INDEX($C$5:$C$12,MATCH(90,$H$5:$H$12,0)),INDEX($F$5:$F$12,MATCH(SUMIFS($F$5:$F$12,$H$5:$H$12,"<"&90),$I$5:$I$12,1)+1)*(90-(INDEX($H$5:$H$12,MATCH(SUMIFS($F$5:$F$12,$H$5:$H$12,"<"&90),$I$5:$I$12,1))))/(INDEX($G$5:$G$12,MATCH(SUMIFS($F$5:$F$12,$H$5:$H$12,"<"&90),$I$5:$I$12,1)+1))+(INDEX($B$5:$B$12,MATCH(SUMIFS($F$5:$F$12,$H$5:$H$12,"<"&90),$I$5:$I$12,1)+1)))
Maybe this will work better for you. Sorry about that,