另解{=SUM(B$2:OFFSET(B2,,,MATCH(1=1,B2:B15<>"",)))
C2=IF(B1>0,SUMPRODUCT(OFFSET(B2,,,MATCH(1=1,B2:B15<>"",))),)+N(C1)
另解{=SUM(B$2:INDEX(B2:B20,MATCH(1=0,B2:B20="",-1)))
下拉完全 才正確 C2=IF(B2="",C3,SUM(B$2:B2))