增加一列辅助列,判断用户是否访问过接口
编写代码 =IF(ISERROR(VLOOKUP(D2&F$1,A$2:A$10&B$2:B$10,1,FALSE)),0,1)
最后计算总和
=SUMPRODUCT(E2:E6,F2:F6)
=COUNTIF(A2:A11,"小明1")=COUNTIF(A2:A11,"小明2")以此类推