|
454084619
| 来自北京
=IF(AND(C2>=MIN($A$2:$B$9),C2
=COUNTIF(OFFSET(Sheet1!$A12,,,1,MATCH(MAX(Sheet1!12:12),Sheet1!12:12,)),"=")Sheet1B2=IFERROR(INDEX(Sheet2!$C:$C,MATCH($A2&B$1,Sheet2!$A:$A&Sheet2!$B:$B,)),""),,Ctrl+Shift+Enter,。
=SUMPRODUCT((A$2:A$10=M8)*(ISNUMBER(B$2:K$10))*(B$2:K$10>0)) |
|