扫码加入数据分析学习群

迟到次数：=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="周末"