¦p¦ó¦b²Ä¤@¦¸¤ñ¹ï§ä¤£¨ì®É¦Û°Ê¦A¤ñ¹ï²Ä¤G±ø¥ó®M¨ú²Å¦XªºÈ??
- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10

|
=IF(SUMPRODUCT((©ú²Ó!$A$2:$A$23=A2)*(©ú²Ó!$B$2:$B$23=B2)*(©ú²Ó!$D$2:$D$23)),SUMPRODUCT((©ú²Ó!$A$2:$A$23=A2)*(©ú²Ó!$B$2:$B$23=B2)*(©ú²Ó!$D$2:$D$23)),SUMPRODUCT((©ú²Ó!$A$2:$A$23=A2)*(©ú²Ó!$C$2:$C$23=B2)*(©ú²Ó!$D$2:$D$23))) |
|
|
|
|
|
|
- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10

|
A2=INDEX(©ú²Ó!$A$1:$A$1000,SMALL(IF(©ú²Ó!$A$2:$A$100<>"",ROW($A$2:$A$100),999),ROW(A1)))&"" °}¦C¤½¦¡
®Æ¸¹¬Ona®Æ¸¹ÁÙ¬Ob®Æ¸¹?¥i¥ÎVLOOKUP§ì¨ú |
|
|
|
|
|
|