找出表格是否有重复数据: =IF(AND(G20=G19,D20=D19),"是","否") 筛选移除【重复的数据】然后开始统计 =SUBTOTAL(9,E2:E287) 转载于:https://www.cnblogs.com/LuoEast/p/10284090.html