Question

excel统计去除重复项后的个数？

如何统计本列中媒体数量（重复的按照一个计算）？

Answer 1

在B2中输入或复制粘贴下列公式
=COUNTIFS(表1!$G:$G,$A2,表1!$B:$B,">="&INDIRECT("H"&COLUMN(B2)),表1!$B:$B,"<="&INDIRECT("H"&COLUMN(B2)))
下拉填充

Answer 2

在B2中输入或复制粘贴下列公式
=COUNTIFS(表1!$G:$G,$A2,表1!$B:$B,">="&INDIRECT("H"&COLUMN(B2)),表1!$B:$B,"<="&INDIRECT("H"&COLUMN(B2)))
下拉填充

Answer 3

在B2中输入或复制粘贴下列公式
=COUNTIFS(表1!$G:$G,$A2,表1!$B:$B,">="&INDIRECT("H"&COLUMN(B2)),表1!$B:$B,"<="&INDIRECT("H"&COLUMN(B2)))
下拉填充

Answer 4

在B2中输入或复制粘贴下列公式
=COUNTIFS(表1!$G:$G,$A2,表1!$B:$B,">="&INDIRECT("H"&COLUMN(B2)),表1!$B:$B,"<="&INDIRECT("H"&COLUMN(B2)))
下拉填充

Answer 5

在B2中输入或复制粘贴下列公式
=COUNTIFS(表1!$G:$G,$A2,表1!$B:$B,">="&INDIRECT("H"&COLUMN(B2)),表1!$B:$B,"<="&INDIRECT("H"&COLUMN(B2)))
下拉填充