![如何计算单元格区域中出现的次数?](https://linux22.com/image/1580963/%E5%A6%82%E4%BD%95%E8%AE%A1%E7%AE%97%E5%8D%95%E5%85%83%E6%A0%BC%E5%8C%BA%E5%9F%9F%E4%B8%AD%E5%87%BA%E7%8E%B0%E7%9A%84%E6%AC%A1%E6%95%B0%EF%BC%9F.png)
答案1
您需要使用DATEVALUE
来正确评估日期。尝试:
=COUNTIFS(contacts!G8:KT992,">="&DATEVALUE("1/1/2019"),contacts!G8:KT992"<="&DATEVALUE("3/31/2019"),contacts!G8:KT992,"="&Client Interested)
您需要使用DATEVALUE
来正确评估日期。尝试:
=COUNTIFS(contacts!G8:KT992,">="&DATEVALUE("1/1/2019"),contacts!G8:KT992"<="&DATEVALUE("3/31/2019"),contacts!G8:KT992,"="&Client Interested)