excel2007 COUNTIFS

最新推荐文章于 2024-07-24 09:51:02 发布

spencer_tseng

最新推荐文章于 2024-07-24 09:51:02 发布

阅读量208

点赞数

分类专栏： office 文章标签： office

本文链接：https://blog.csdn.net/spencer_tseng/article/details/121171439

版权

office 专栏收录该内容

36 篇文章 0 订阅

订阅专栏

=COUNTIFS(钉钉考勤明细!A:A,B3,钉钉考勤明细!F:F,"正常")*0.5+COUNTIFS(钉钉考勤明细!A:A,B3,钉钉考勤明细!H:H,"正常")*0.5

=COUNTIFS(钉钉考勤明细!A:A,B3,钉钉考勤明细!F:F,"请假")*0.5+COUNTIFS(钉钉考勤明细!A:A,B3,钉钉考勤明细!H:H,"请假")*0.5

=COUNTIFS(钉钉考勤明细!A:A,B3,钉钉考勤明细!F:F,"*迟到*")*0.5+COUNTIFS(钉钉考勤明细!A:A,B3,钉钉考勤明细!H:H,"*迟到*")*0.5


=COUNTIFS(钉钉考勤明细!A:A,B3,钉钉考勤明细!F:F,"*补卡*")*0.5+COUNTIFS(钉钉考勤明细!A:A,B3,钉钉考勤明细!H:H,"*补卡*")*0.5


=COUNTIFS(钉钉考勤明细!A:A,B3,DIM(钉钉考勤明细!F:F,1,2),"=*迟到*")*0.5+COUNTIFS(钉钉考勤明细!A:A,B3,DIM(钉钉考勤明细!H:H,1,2),"=*迟到*")*0.5



=COUNTIFS(钉钉考勤明细!A:A,B3,DIM(钉钉考勤明细!F:F,1,2),"迟到")*0.5+COUNTIFS(钉钉考勤明细!A:A,B3,(钉钉考勤明细!H:H,1,2),"迟到")*0.5