公式优化

于洪旭

=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")