非零连续次数與分组和 (10480)

B2{=(A2>0)*IF(ISERR(1/A1),SUM(OFFSET(A2,,,MATCH(,A3:A21/1,))),B1)

C2{=IF(A2,IF(ISERR(1/A1),SUM(OFFSET(A2,,,MATCH(,A3:A21/1,))),""),IF(A1,,""))

D2=(A2>0)*(N(D1)+1)