=SUM(IF(B$14:B$21>B14,1/COUNTIF(B$14:B$21,B$14:B$21)))+1 上面的

来源：学生作业帮编辑：神马作文网作业帮分类：综合作业时间：2024/09/22 07:29:45

=SUM(IF(B$14:B$21>B14,1/COUNTIF(B$14:B$21,B$14:B$21)))+1 上面的公式可以用语言解释下吗?
1/COUNTIF(B$14:B$21,B$14:B$21)的含义是什么?
如果该公式应用数组的话,意义又是什么?
语言可以诠释下吗?

excel中为什么这个公式=SUM(COUNTIF(B21:AH21,$M$2:$X$2))不能出现后面的公式其实是一个数组公式,他的含义是以$M$2:$X$2里的每一个内容

=SUM(IF(B$14:B$21>B14,1/COUNTIF(B$14:B$21,B$14:B$21)))+1 上面的 =IF(COUNTIF($A$1:$B$21,B1)>1,"重复","") 公式是正确的,=SUMPRODUCT((B$2:B$14>B2)/COUNTIF(B$2:B$14,B$2:B$14)) =SMALL(IF(COUNTIF($B$2:$B$14,$D$2:$D$14),ROW($B$2:$B$14),655 =IF(COUNTIF(b:b,b1&"*")>1,"重复","唯一") 这个筛选B拦的公式是否正确 =IF(ROW(A1)>SUM($B$1:$B$19),"",INDEX(A:A,SMALL(IF($B$1:$B$19 VLOOKUP(B$9&ROW(A1),IF({1,0},$B$2:$B$6&COUNTIF(INDIRECT("b2: =IF(B14=1,"d","b"),if(e14=1,"c","a"))是什么怎么解释的 SUMPRODUCT((B$1:B$100>B1)*(1/COUNTIF($B$1:$B$100,$B$1:$B$100 excel中=COUNTIF($B:$B,B1)>1 =SUMPRODUCT(($B$3:$B$8>$B3)/COUNTIF($B$3:$B$8,$B$3:$B$8))+1 函数表达式=if(SUM(A:A)=SUM(B:B),"","数据有误")''的含义是什么