|
- 【函中201301班】- D19-xcnclzy
- =SUMPRODUCT(ISNUMBER(FIND("04",A3:A18))*(B3:B18))
- =SUMPRODUCT(ISNUMBER(FIND("04",A3:A18))*1,B3:B18)
- =SUMPRODUCT(($A$25:$A$48=D31)*($B$25:$B$48>=LARGE($B$25:$B$48,5)))
- =SUMPRODUCT(($A$25:$A$48=D25)*(IF($B$25:$B$48="",0,RANK($B$25:$B$48,$B$25:$B$48)<=5)))三键
- =SUMPRODUCT(($A$25:$A$48=D25)*($B$25:$B$48>=LARGE($B$25:$B$48,5))*$B$25:$B$48)
- =SUMPRODUCT(($A$54:$A$60=D54)*(--$B$54:$B$60>=LARGE(--$B$54:$B$60,5)))
- =SUMPRODUCT(((A64:A70="A")+(A64:A70="C"))*1,--(B64:B70))
- =SUM(IF(A64:A70=({"A","C"}),--B64:B70))三键
复制代码 |
评分
-
查看全部评分
|