二欄數值分別相加 並排序 (15096)

E2{=IFERROR(SMALL(IF((C$2:C$9>0)+(TRANSPOSE(B$2:B$9)>0)=2,C$2:C$9+TRANSPOSE(B$2:B$9)),ROW(A1)),"")

F2{=IFERROR(SMALL(IF((C$2:C$9>0)+(TRANSPOSE(B$2:B$9)>0)=2,C$2:C$9),ROW(A1))+N(OFFSET(B$2,MOD(ROW(A1)-1,COUNTA(B:B)-1),)),"")