[已解决]多条件倒序排名

cqkxlhw

我看到一个多条件排序的公式，现在想进行多条件倒序排名，请教如何设计公式？具体情况看附件吧。

最佳答案

月排行榜 / 总排行榜

1091126096

2014-9-26 22:57

1. =SUM((D$2:D$5000=D2)*(C$2:C$5000=C2)*(A$2:A$5000=A2)*(E$2:E$5000<E2))+1
   
2. =SUMPRODUCT((D$2:D$5000=D2)*(C$2:C$5000=C2)*(A$2:A$5000=A2)*(E$2:E$5000<E2))+1

复制代码

跳转到最佳答案楼层

1091126096

1. =SUM((D$2:D$5000=D2)*(C$2:C$5000=C2)*(A$2:A$5000=A2)*(E$2:E$5000<E2))+1
   
2. =SUMPRODUCT((D$2:D$5000=D2)*(C$2:C$5000=C2)*(A$2:A$5000=A2)*(E$2:E$5000<E2))+1

复制代码