=(B6=0)*(B7>0)+(D6=0)*(D7>0)+(G6=0)*(G7>0)也可以=SUMPRODUCT((B6:G6=0)*(B7:G7>0)*{1,0,1,0,0,1})
在I6中输入或复制粘贴下列公式=SUMPRODUCT((B6=0)*(B7>0))+SUMPRODUCT((D6=0)*(D7>0))+SUMPRODUCT((G6=0)*(G7>0))下拉填充
