我写的公式到底哪里错了，为什么不能计算呢？

谷谷

=SUMPRODUCT((B$4:B$56=LOOKUP(,-FIND({"","值班员","内勤","外勤","调车长","连结员"},B4),{"其他","值班员","内勤","外勤","调车长","连结员"}))*(H$4:H$56)*(P$4:P$56))
10月份考勤2021-12-10.zip (24.09 KB, 下载次数: 14)

2021-12-17 15:48 上传

点击文件名下载附件
10月份考勤2021-12-10.zip

慧怡

=SUMPRODUCT((月度考勤表!$F$2:$V$100=$D4)*(月度考勤表!$W$2:$W$100=LEFT(E$3))*(月度考勤表!$F$1:$V$1=$C4)*(月度考勤表!$E$2:$E$100=MID($B4,3,1)))