- ©«¤l
- 1387
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1397
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-11-3
|
B15:B17{=IFERROR(INDEX(¤u§@ªí1!B:B,SMALL(IF(MATCH(¤u§@ªí1!B$15:B$17,¤u§@ªí1!B$15:B$17,)=ROW($1:$3),ROW(B$15:B$17)),ROW(A1))),"")
D15:D17=IF(B15="","",SUMIF(¤u§@ªí1!B$15:B$17,B15,¤u§@ªí1!D$15:D$17))
F15:F17=IF(E3="","",SUMIF(¤u§@ªí1!E$15:E$17,E3,¤u§@ªí1!I$15:I$17)) |
|