¡i½Ð±Ð¡j¦p¦ó¥[Á`¤£¦P¬¡¶Ã¯©Ò¹ïÀ³¸ê®Æ
- ©«¤l
- 617
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 662
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-3-7
|
¥»©«³Ì«á¥Ñ 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 |
|
|
|
|
|
|