2020-05-26
閱讀量:
1887
加班 函數(shù)要牢記哦
1 病=COUNTIF(H5:AK5,"病")
2 事=COUNTIF(H5:AK5,"事")
3 平時加班=SUMIFS(H5:AK5,$H$3:$AK$3,"<=6",$H$3:$AK$3,">=2")-B5*8
4 周末加班=SUMIF($H$3:$AK$3,1,H5:AK5)+SUMIF($H$3:$AK$3,7,H5:AK5)






推薦帖子
0條評論
0條評論
0條評論