=sum(COUNTIFS(Data!G:G,">="&B8,Data!G:G,"<"&B9,Data!M:M,{"远程投诉处理","上门投诉处理","退换货及返厂"}))
你的公式都写错了。你参考楼下兄弟的公式
