验证出现
=IFERROR(IF(MATCH(A1,$C$1:$C$225,0)>=1,"出现",""),"")
=IFERROR(IF(MATCH(C1,$A$1:$A$228,0)>=1,"出现",""),"")
验证出现 查找支票号码 首先要将号码转换为文本格式
=IFERROR(IF(MATCH(A1,欧东!I:I,0)>=1,"出现",""),"")
查找统计
=SUMIF(现金!$K$2:$K$24724,B16,现金!$G$2:$G$24724)
查找账号公式
=VLOOKUP(D2,账号!A:B,2,0)
查找重复
=IF(COUNTIF($A$2:$A$781,A2)>1,"重复","OK")
验证账号有没有重复
=IF(COUNTIF($B$2:$B$700,B2&"*")>1,"重复","OK")
验证名字有没有重复
=IF(COUNTIF($A$2:$A$700,A2)>1,"重复","OK")
验证出现
=IFERROR(IF(MATCH(A1,现金结果!$G$16:$G$131,0)>=1,"出现",""),"")
=IFERROR(IF(MATCH(A9,现金结果!$B$16:$B$131,0)>=1,"出现",""),"")
数据三重条件统计
=SUM((资金明细!$C$2:$C$2266="证券买入清算")*(资金明细!$E$2:$E$2266=A2)*资金明细!$O$2:$O$2266)
按CTRL+SHIFT+ENTER
统计非空白合计（相当于筛选合计）
=SUMIF(欧东!K:K,"*",欧东!F:F)
统计时间段内的收入 支出数
=SUM(IF(欧东!$C$1:$C$4000<=H1,IF(欧东!$C$1:$C$4000>=G1,欧东!$F$1:$F$4000),0)) 按CRTL+SFHIT+ENTER
E6公式=SUM(IF(销售统计!$A$4:$A$4000<=F4,IF(销售统计!$A$4:$A$4000>=F3,销售统计!$K$4:$K$400),0))
这个公式应该是数组公式，需要三键结束（ctrl+shift+enter）
或者=SUMPRODUCT((MONTH(销售统计!A4:A16)=MONTH(F3))*销售统计!K4:K16)普通公式
E7公式=SUMPRODUCT((MONTH(销售统计!A4:A16)=MONTH(F3))*销售统计!P4:P16)