带条件的排名

问题：带条件的排名 

函数公式解决：

=SUM((K2<=E$2:E$24)*(A$2:A$24=G2)*(B$2:B$24=H2)*(C$2:C$24=I2)*(LEFT(D2:D24)="H"))
=SUM((K3<=E$2:E$24)*(A$2:A$24=G3)*(B$2:B$24=H3)*(C$2:C$24=I3))
=SUM((K4<=E$2:E$24)*(A$2:A$24=G4)*(B$2:B$24=H4))
=SUM((K5<=E$2:E$24)*(A$2:A$24=G5))

K5<=E2:E24，将返回结果中的TRUE相加，所得到的结果就是K5在E2:E24中的排名，以此结果乘以相应的满足条件的结果，就是带条件的排名。