EXCEL统计不重复姓名人数的个数
A15输入公式=countif(A1:A14,"<=69")-countif(A1:A14,"<60")或输入下面的公式后按SHIFT+CTRL+ENTER=SUM(COUNTIF(A1:A14, "<"&{60,70})*{-1,1})
