下面的公式如何简化,我想统计某个单位在一周内(或是统计周期内),拜访客户次数。
=COUNTIFS(CRM拜访!DP:DP,B2,CRM拜访!DR:DR,"2024/6/1")+COUNTIFS(CRM拜访!DP:DP,B2,CRM拜访!DR:DR,"2024/6/2")+COUNTIFS(CRM拜访!DP:DP,B2,CRM拜访!DR:DR,"2024/6/3")+COUNTIFS(CRM拜访!DP:DP,B2,CRM拜访!DR:DR,"2024/6/4")+COUNTIFS(CRM拜访!DP:DP,B2,CRM拜访!DR:DR,"2024/6/5")+COUNTIFS(CRM拜访!DP:DP,B2,CRM拜访!DR:DR,"2024/6/6")+COUNTIFS(CRM拜访!DP:DP,B2,CRM拜访!DR:DR,"2024/6/7")