excel表格中的连续值0怎么打

1.电子表格,EXCEL,如何求前面,连续为0 的个数

R4=COUNTIF(OFFSET(G$3,IF(ISERROR(LOOKUP(1,0/(G$3:G30),ROW(G$3:G3))),0,LOOKUP(1,0/(G$3:G30),ROW(G$3:G3))-ROW(G$3)),0,ROW()-IF(ISERROR(LOOKUP(1,0/(G$3:G30),ROW(G$3:G3))),ROW(G$3),LOOKUP(1,0/(G$3:G30),ROW(G$3:G3))),1),0)

或者=IF(G30,0,ROW(G3)-IF(ISERROR(LOOKUP(1,0/(G$3:G30),ROW($3:3))),2,LOOKUP(1,0/(G$3:G30),ROW($3:3))))

向右向下复制