總和 最後空白右邊數字 (14184)

J2=SUM(OFFSET(H2,,,,IFERROR(LOOKUP(1,0/(B2:H2=0),COLUMN(A:G)),)-7))

另解{=SUM(INDEX(2:2,MAX(IF(B2:H2="",COLUMN(B:H),1))):H2)

另解{=SUM(OFFSET(H2,,,,MATCH(6,(A2:G2>="")^-1)-8))