请问如何按时间来统计数据

芸芸众生

各位大侠，请问附件中，我能否通过设置选择开始日期和结束日期来统计下面的数据吗？谢谢

cutecpu

C15 公式: =COUNTIFS(B4:B9,">="&D11,B4:B9,"<="&D12)
E15 公式: =COUNTIFS(F4:F9,"男",B4:B9,">="&D11,B4:B9,"<="&D12)
E16 公式: =COUNTIFS(F4:F9,"女",B4:B9,">="&D11,B4:B9,"<="&D12)
E17 公式: =COUNTIFS(E4:E9,"自用",B4:B9,">="&D11,B4:B9,"<="&D12)
E18 公式: =COUNTIFS(E4:E9,"送礼",B4:B9,">="&D11,B4:B9,"<="&D12)
H15 公式: =COUNTIFS(G4:G9,"20以下",B4:B9,">="&D11,B4:B9,"<="&D12)
H16 公式: =COUNTIFS(G4:G9,"20~30",B4:B9,">="&D11,B4:B9,"<="&D12)
H17 公式: =COUNTIFS(G4:G9,"30~40",B4:B9,">="&D11,B4:B9,"<="&D12)
H18 公式: =COUNTIFS(G4:G9,"40以上",B4:B9,">="&D11,B4:B9,"<="&D12)
K15 公式: =COUNTIFS(J4:J9,"本地",B4:B9,">="&D11,B4:B9,"<="&D12)
K16 公式: =COUNTIFS(J4:J9,"外地",B4:B9,">="&D11,B4:B9,"<="&D12)
K17 公式: =COUNTIFS(J4:J9,"游客",B4:B9,">="&D11,B4:B9,"<="&D12)
K18 公式: =COUNTIFS(I4:I9,"Y",B4:B9,">="&D11,B4:B9,"<="&D12)

※如果有解決您的問題，再請將帖子設為[已解決]

祝順心，南無阿彌陀佛！

芸芸众生

cutecpu 发表于 2020-1-15 23:35
C15 公式: =COUNTIFS(B4:B9,">="&D11,B4:B9,"="&D11,B4:B9,"="&D11,B4:B9,"="&D11,B4:B9,"="&D11,B4:B9,"=" ...

非常感谢大侠的帮助，顺利解决！！谢谢！