我的公式:平时加班=SUMIFS(H5:AK5,$H$3:$AK$3,">1",$H$3:$AK$3,"<7",H5:AK5,">8")-COUNTIFS($H$3:$AK$3,">1",$H$3:$AK$3,"<7",H5:AK5,">8")*8
周末加班=SUMIF(H$3:AL$3,1,H5:AL5)+SUMIF(H$3:AL$3,7,H5:AL5)
各位大神有什么更简单的方法么?
三个资料Q群下载不了也转发不了,先放这里Fine_tuning.zipLangChain.zipdata_clear.rar