lulututu

2020-06-13   阅读量: 150

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 关注作者 收藏

评论(1)

傅奕程
2020-06-13
好细致
0.0108 1 0 回复
lulututu
2020-06-13
谢谢猪
0.0000 0 0 回复

推荐帖子


    暂无数据

推荐课程