總和 依出現非空往前 (13765)

R2=IF(ROW(A1)>COUNTA(B$3:P$3),"",ROW(A1))

S2{=IF(R2="","",SUM(OFFSET(B$2,,,,MAX(SMALL(IF(B$3:P$3<>"",COLUMN(A:O)),ROW(A1))))))