问题：带条件的排名
函数公式解决：
=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中的排名，以此结果乘以相应的满足条件的结果，就是带条件的排名。