Excel =SUMPRODUCT((D$2:D$19>D2)*(1/(COUNTIF(D$2:D$19,D$2:D$1

来源：学生作业帮编辑：作业帮分类：综合作业时间：2024/05/16 00:40:33

Excel =SUMPRODUCT((D$2:D$19>D2)*(1/(COUNTIF(D$2:D$19,D$2:D$19))))+1
在excel中有个中国式排序的函数,=SUMPRODUCT((D$2:D$19>D2)*(1/(COUNTIF(D$2:D$19,D$2:D$19))))+1
我会运用这个函数了,而且也知道1/(countif（D$2:D$19,D$2:D$19))的意思了.但请问（D$2:D$19>D2)是什么意思?(D$2:D$19>D2)*(1/(COUNTIF(D$2:D$19,D$2:D$19)))又是什么意思?请高手指点一下,不胜感激!

（D$2:D$19>D2)统计大于D2的值的单元格数量
(D$2:D$19>D2)*(1/(COUNTIF(D$2:D$19,D$2:D$19)))统计大于D2的值且不重复的单元格数量
再问：为什么不用countif（D$2:D$19>D2)而可以直接用（D$2:D$19>D2)就能统计大于D2的值的单元格数量了呢？还有，麻烦您再详细解释一下“(D$2:D$19>D2)*(1/(COUNTIF(D$2:D$19,D$2:D$19)))统计大于D2的值且不重复的单元格数量 ”的原理。谢谢啦！
再答： sumproduct是数组函数，可以把D$2:D$19>D2成立和不成立的情况都罗列出来，成立的记为1，不成立的记为0 ，然后与1/(COUNTIF(D$2:D$19,D$2:D$19）一一对应相乘（前面你说你知道1/(COUNTIF(D$2:D$19,D$2:D$19）的意思，就好理解相乘的目的是什么，就是去掉重复的项），再求和，就是大于D2的值且不重复的单元格数量。

Excel =SUMPRODUCT((D$2:D$19>D2)*(1/(COUNTIF(D$2:D$19,D$2:D$1 ^(\d{1,2}\.\d\.\d) COUNTIF($D$5:$D$8,$B4)=0,COUNTIF($D$5:$D$8,$B4)=1,COUNTIF($D Excel中函数countif(D:D, 求解释EXCEL公式求高手解释这个公式=IF(ROW(A3)>COUNTIF(简表!$D:$D,$D$2),"",IND scanf("%2d%*2d%1d",&x,&y);是什么意思%2d%*2d%1d {=SUM(--($D$1:$D1$D$2:$D2))} 求这个函数的意思? 1D,2D,3D,4D我知道了.5D是啥意思? D -):-D D. 1D、2D与3D的区别