2020-06-13
阅读量:
2778
EXCEL 常用函数
迟到次数：=COUNTIF(B2:K2,"b")
旷课次数：=COUNTIF(B2:K2,"c")
一号和二号都迟到的人：=COUNTIFS(B2:B11,"b",C2:C11,"b")
计算C列在B列的累计数据：=SUM($B$2:B2) 然后填充柄填充整列
借方金额求和：=SUMIF(D3:D14,"借",H3:H14)
贷方金额求和：=SUMIF(D3:D14,"贷",H3:H14)
工行借方求和:=SUMIFS(H3:H14,E3:E14,"工行",D3:D14,"借")
工行金额>=80000金额求和:=SUMIFS(H3:H14,E3:E14,"工行",H3:H14,">=8000")
本月最后一天：=EOMONTH(A2,0)
本月天数：=DAY(B2)
是否周末：=IF(WEEKDAY(A2,2)>5,"周末","否")
周末设置条件格式：=$D2="周末"
16.4720
2
4
关注作者
收藏
发表评论
