SUMPRODUCT+COUNTIFS如何去空值? 5
ROUND(SUMPRODUCT(($D$2:$D$50=E2)*($C$2:$C$50="事故")*(1/COUNTIFS($B$2:$B$50,$B$2:$B$50,...
ROUND(SUMPRODUCT(($D$2:$D$50=E2)*($C$2:$C$50="事故")*(1/COUNTIFS($B$2:$B$50,$B$2:$B$50,$D$2:$D$50,$D$2:$D$50,$C$2:$C$50,$C$2:$C$50),现在只能取数2到50行,但是数据是动态的每天会增加,如何让这个公式可以去除空值呢?
展开
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询