由後往前第一區間值 往後總和 (15140)

B3:B9=SUM(OFFSET(C3,,IFERROR(LOOKUP(1,0/(C3:Z3<$J$1)/(C3:Z3>$L$1),COLUMN(C:Z)-3),),,99))

C3:Z9格式化=SUM(C3:$Z3)<=$B3