¡i½Ð±Ð¡j¦p¦ó¥[Á`¤£¦P¬¡¶Ã¯©Ò¹ïÀ³¸ê®Æ
- ©«¤l
- 15
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 69
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-9-8
- ³Ì«áµn¿ý
- 2024-8-5
|
¡i½Ð±Ð¡j¦p¦ó¥[Á`¤£¦P¬¡¶Ã¯©Ò¹ïÀ³¸ê®Æ
¤j®a¦n,
§Æ±æ±q¹ï·Óªí¤¤¥[Á`¨C³æ¦ì¤£¦P¶O¥Î¤ä¥X¤§ª÷ÃB¡A©ósummary¬¡¶Ã¯¤¤¶À¦â©³§e²{
¦]¸Õ¹Lvlookup()»Psumif()¦ýn¹ïÀ³ªº¥Ø¼ÐȦ³Äæ»P¦C¼ÐÃD¡A¤£ª¾¬O§_¦³¨ä¥L§ó¦n¤èªk¥i¦Û°Ê±a¤J??
¥H¤W
«D±`·PÁÂ~~^^ |
|
mmap
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
![½×¾ÂºaÅA¾±³¹ ½×¾ÂºaÅA¾±³¹](images/common/medal14.gif) ![½×¾ÂÃÙ§U¾±³¹ ½×¾ÂÃÙ§U¾±³¹](images/common/medal3.gif) ![¼ö¯P°Ñ»P¾±³¹ ¼ö¯P°Ñ»P¾±³¹](images/common/medal7.gif) ![2014°¨¦~¥þ¶Ô¼ú³¹ 2014°¨¦~¥þ¶Ô¼ú³¹](images/common/ma.gif) ![2015¦Ï¦~¥þ¶Ô¼ú³¹ 2015¦Ï¦~¥þ¶Ô¼ú³¹](images/common/yang.gif) ![2016µU¦~¥þ¶Ô¼ú³¹ 2016µU¦~¥þ¶Ô¼ú³¹](images/common/hou.gif)
|
¦^´_ 1# mmap
¨Ï¥ÎSUMIF¨ç¼Æ§@ªk
B2
=SUMIF(¹ï·Óªí!$A:$A,$A2,INDEX(¹ï·Óªí!$A:$F,,MATCH(B$1,¹ï·Óªí!$1:$1,)))
¥k©Ô
B2:F3 ¤U©Ô |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 15
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 69
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-9-8
- ³Ì«áµn¿ý
- 2024-8-5
|
«D±`·PÁÂ~~
¥i¥H¬Ù¤U«Ü¦h®É¶¡~~
®Ä²v§ó´£¤É¤F~~^^ |
|
mmap
|
|
|
|
|
- ©«¤l
- 206
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 218
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN10
- ³nÅ骩¥»
- OFFICE 365
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW¥x¥_
- µù¥U®É¶¡
- 2010-5-15
- ³Ì«áµn¿ý
- 2023-6-18
|
B2
=SUMPRODUCT(($A2=¹ï·Óªí!$A$2:$A$871)*(¹ï·Óªí!$B$1:$F$1=B$1)*¹ï·Óªí!$B$2:$F$871) |
|
|
|
|
|
|
- ©«¤l
- 15
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 69
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-9-8
- ³Ì«áµn¿ý
- 2024-8-5
|
½Ð°Ý¡G¬O§_¦³¾÷·|¤£»Ýn¿é¤J¶O¥Î¦WºÙ©O?
¦p¹³³æ¦ì¥N¸¹¤@¼Ë¥i¥H=B¢C1¤§Ãþªº¤èªk
¦]¬°¶O¥Î¦WºÙ¬Û·í¦h == |
|
mmap
|
|
|
|
|
- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
![2014°¨¦~¥þ¶Ô¼ú³¹ 2014°¨¦~¥þ¶Ô¼ú³¹](images/common/ma.gif) ![2013³D¦~¥þ¶Ô¼ú³¹ 2013³D¦~¥þ¶Ô¼ú³¹](images/common/she.gif) ![¼ö¯P°Ñ»P¾±³¹ ¼ö¯P°Ñ»P¾±³¹](images/common/medal7.gif)
|
¥»©«³Ì«á¥Ñ p212 ©ó 2014-9-12 17:09 ½s¿è
¦^´_ 1# mmap
1¡B©ó¡u¹ï·Óªí¡v¤u§@ªí¿ï¨úA1:F871¡A«öCtrl+Shift+F3¡A¤Ä¿ï¥H¡u³»ºÝ¦C¡v¬°¦WºÙ¡C
2.©ó¡usummary¡v¤u§@ªí¤§
Àx¦s®æB2¿é¤J=SUMPRODUCT((³æ¦ì¥N¸¹=$A2)*ºë¯«¸ÉÀv¶O)
Àx¦s®æC2¿é¤J=SUMPRODUCT((³æ¦ì¥N¸¹=$A2)*¯S§÷¶O)
Àx¦s®æD2¿é¤J=SUMPRODUCT((³æ¦ì¥N¸¹=$A2)*¿¯¹¶O)
Àx¦s®æE2¿é¤J=SUMPRODUCT((³æ¦ì¥N¸¹=$A2)*Á`¶O¥Î)
Àx¦s®æF2¿é¤J=SUMPRODUCT((³æ¦ì¥N¸¹=$A2)*³¡¥÷t¾á)
¤Ï¥Õ¡usummary¡v¤u§@ªí¤§B2:F3¡A¦V¤U½Æ»s¤½¦¡¡C
½Ð°Ñ¦Ò¡I |
|
|
|
|
|
|