EXCEL-跨表/跨页签数据按条件统计求和
2020-05-20 本文已影响0人
WXL_JIANSHU
直接上代码：
=SUM(COUNTIFS(INDIRECT("国内进港!B1:B9999"),A4,INDIRECT("国内进港!G1:G9999"),"一般BUG",INDIRECT("国内进港!H1:H9999"),"已解决"),COUNTIFS(INDIRECT("国内进港!B1:B9999"),A4,INDIRECT("国内进港!G1:G9999"),"严重BUG",INDIRECT("国内进港!H1:H9999"),"已解决"))
效果，不想发，自己实践去~
