½Ð°Ý¦p¦ópºâ¨CÓ¤H¯Z§O¦¸¼Æ?
- ©«¤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
|
½Ð°Ý¦p¦ópºâ¨CÓ¤H¯Z§O¦¸¼Æ?
¦U¦ì¦n
¦]»Ýn²Îp¨CÓ¤H¤W¯Z¯Z§O¦¸¼Æ
¦pªþ¥ó»¡©ú
¦]¬°¸Õ¤F´XÓ¨ç¼Æ³£·d¤£©w¡A¥u¦n½Ð±Ð¦U°Ý«e½ú |
|
mmap
|
|
|
|
|
- ©«¤l
- 561
- ¥DÃD
- 160
- ºëµØ
- 0
- ¿n¤À
- 725
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS
- ³nÅ骩¥»
- xp
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2014-9-10
- ³Ì«áµn¿ý
- 2024-8-7
|
«u §Ú¤§PC .RAR µLªk¶} .ZIP ¤~¥i¶} ..... |
|
ù
|
|
|
|
|
- ©«¤l
- 396
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 425
- ÂI¦W
- 1
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2013-7-2
- ³Ì«áµn¿ý
- 2024-8-23
|
¦^´_ 1# mmap
¤j¤j¡A½Ð°Ý¤H¤upºâªºµ²ªG¬°¦ó¡H¥i§_¨q¥X¨Ó¬Ý¤@¤U¡C
¬Ý¤£¤ÓÀ´³oÓªí¡A¤£ª¾¸Ó¦p¦óÀ°¥L¤U¤½¦¡¡C |
|
|
|
|
|
|
- ©«¤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
|
|
mmap
|
|
|
|
|
- ©«¤l
- 396
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 425
- ÂI¦W
- 1
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2013-7-2
- ³Ì«áµn¿ý
- 2024-8-23
|
¦^´_ 4# mmap
b8=SUMPRODUCT(((¯Z§O²M³æ!$A$2:$A$11=B$2)+(¯Z§O²M³æ!$A$2:$A$11=B$3)+(¯Z§O²M³æ!$A$2:$A$11=B$4)+(¯Z§O²M³æ!$A$2:$A$11=B$5)+(¯Z§O²M³æ!$A$2:$A$11=B$6)+(¯Z§O²M³æ!$A$2:$A$11=B$7))*(¯Z§O²M³æ!$B$2:$B$11=$A8))
©¹¥k©¹¤U½Æ»s§Y¥i¡A¦pªG·QÅý¤½¦¡¬Ý°_¨Ó¤£n¨º»ò¤S¯ä¤Sªø¡A¥i¥H§â¯Z§O²M³æ¸Ìªºa2:a11¤Îb2:b11¤À§O©w¸q¦WºÙ¡A´N¤£¥ÎÅã¥Ü¡y¯Z§O²M³æ!$A$2:$A$11¡z¨º»òªø¤F |
|
|
|
|
|
|
- ©«¤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
|
B8=SUMPRODUCT((MATCH(B$2:B$7,¯Z§O²M³æ!$A$2:$A$11,)<=ROW(A1)*3)*1)-SUM(F$7:F7) |
|
|
|
|
|
|
- ©«¤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
|
|
mmap
|
|
|
|
|
- ©«¤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
|
¥»©«³Ì«á¥Ñ Hsieh ©ó 2015-1-1 22:05 ½s¿è
½Ð°Ý¤j¤j
B8=SUMPRODUCT((MATCH(B$2:B$7,¯Z§O²M³æ!$A$2:$A$11,)<=ROW(A1)*3)*1)-SUM(F$7:F7)
©¹¤U½Æ»sÈ«o¬O¿ù»~
¬O§_¦³n¯S§Oª`·Nªº©O? |
|
mmap
|
|
|
|
|
- ©«¤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
|
À³¬O=SUMPRODUCT((MATCH(B$2:B$7,¯Z§O²M³æ!$A$2:$A$11,)<=ROW(A1)*3)*1)-SUM(B$7:B7) |
|
|
|
|
|
|