=SUMPRODUCT(1/COUNTIF(A1:A20,A1:A20)) 与=sum(1/COUNTIF(A1:A20

=SUMPRODUCT(1/COUNTIF(A1:A20,A1:A20)) 与=sum(1/COUNTIF(A1:A20 =sumproduct(1/countif(A1:A20:A1:A20)) 请帮我用文字描述下这个公式的计算过程, EXCEL {=SUMPRODUCT(1/COUNTIF(A1:A7,A1:A7))} =sum(1/countif(A1:A100,A1:A100)) 英语翻译SUM(SUMIF(INDIRECT("'"&ROW($1:$1)&"'!A1:A20"),$A1,INDIRE =IF(COUNTIF(A$1:A1,A1)=1,COUNTIF(A:A,A1),"") COUNTIF(A$1:A1,A1)=1和COUNTIF(A:A,A1),期待您的回复. 统计A1:A20之间好与坏各有几个,用COUNTIF怎么做,我只能统计出一项,另一项就出现循环引用 在数列{an}中,已知a1=-20,a(n+1)=an+4,则|a1|+|a2|+|a3|+...+|a20|= 表格里=SUM(A20, 您好,第二个：=SUMPRODUCT((1/COUNTIF(B1:B11,B1:B11))*(A1:A11=2800)) 求数列a0,a1,a2,a3……a20.已知 a0=0,a1=1,a2=1 a3=a0+2a1+a2