直接上代码：
=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"),"已解决"))
效果，不想发，自己实践去~
直接上代码：
=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"),"已解决"))
效果，不想发，自己实践去~
本文标题：EXCEL-跨表/跨页签数据按条件统计求和
本文链接：https://www.haomeiwen.com/subject/dncnohtx.html
网友评论