sum(1/COUNTIF(range,criteria))是什么意思

sum(1/COUNTIF(range,criteria))是什么意思 countif函数COUNTIF(range,criteria) 这个是它的公式那么=COUNTIF($A$1:$A$1 SUM(COUNTIF(K4:K33,{">=20",">30"})*{1,-1}) 是什么意思? excel 1/countif是什么意思 excel题：统计订购数量大于110且小于850的书的种类数.用countif函数那么Range和Criteria 怎么 =SUM(COUNTIF($C$45:$C$55,">"&{-1,6})*{1,-1}) 这个公式是什么意思,要详细解释 =SUM(COUNTIF(date!H:H,">"&{70,80})*{1,-1}) =SUM(COUNTIF(date!H:H,">"&{70,80})*{1,-1}), =SUM(COUNTIF(K4:K33,{">=20",">30"})*{1,-1}) =sum(1/countif(A1:A100,A1:A100)) =sum(1/countif(B8:K9,B8:K9)) SUM(IF(I:I="","",1/(COUNTIF(I:I,I: