公式优化
=SUMPRODUCT(SUMIFS($L:$L,$A:$A,$A5,$J:$J,{"管理","服务","质量","工作"},$H:$H,$H5))-SUMPRODUCT(SUMIFS($L:$L,$A:$A,$A5,$K:$K,{"2.06","2.15","5.08"},$H:$H,$H5))+IF(SUMPRODUCT(SUMIFS($L:$L,$A:$A,$A5,$K:$K,{"2.06","2.15","5.08"},$H:$H,$H5)) =SUMPRODUCT(SUMIFS($L:$L,$A:$A,$A5,$J:$J,{"管理","服务","质量","工作"},$H:$H,$H5))-TEXT(6-SUMPRODUCT(SUMIFS($L:$L,$A:$A,$A5,$K:$K,{"2.06","2.15","5.08"},$H:$H,$H5)),"!0;0")
页:
[1]