=SUMIF(考勤附件!D2:BM2,“午”,考勤附件!D3:BM3)
=SUMIF(考勤附件!E2:BN2,“晚”,考勤附件!E3:BN3)
文件百度链接可以下载看
链接:https://pan.baidu.com/s/1gKazPG00XYebo1SuIRdVxQ
提取码:72vu
=SUMIF(考勤附件!D2:BM2,“午”,考勤附件!D3:BM3)
=SUMIF(考勤附件!E2:BN2,“晚”,考勤附件!E3:BN3)
文件百度链接可以下载看
链接:https://pan.baidu.com/s/1gKazPG00XYebo1SuIRdVxQ
提取码:72vu