拿走不谢！超实用Excel模板函数

　　1、两张表格筛选重复项

　　=COUNTIF(公司名!$A:$A,C2)

　　2、关键词筛选

　　=IF(COUNT(FIND({"灯","光","布"},B2))>0,"是","否")

　　3、关键词长度筛选

　　=IF(LEN(B2)<5,"NAME","COMPANY")

　　4、计数中使用数组{}需结合SUM使用

　　=SUM(COUNTIFS(pk赛!B:B,周业绩!B7,pk赛!G:G,"一旬",pk赛!C:C,{"新小","新大"}))

　　5、当月业绩求和

　　=SUMIFS(pk赛!E:E,pk赛!B:B,月业绩!B5,pk赛!A:A,">"&EOMONTH(TODAY(),-1),pk赛!A:A,"<="&EOMONTH(TODAY(),0))