如题所述
è§æªå¾
æ¯å¦Aå
B1è¾å ¥
=SUMPRODUCT(1/COUNTIF(A1:A10,A1:A10))
B2=SUMPRODUCT(1/COUNTIF(A2:A19,A2:A19))