µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excel£¸¯ë°Ï
» ¦a°Ï§Oªº¶i³f¼Æ¶q¥[Á`
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
¦a°Ï§Oªº¶i³f¼Æ¶q¥[Á`
¾Ç¨ì¦Ñ¦º
µoµu®ø®§
¥[¬°¦n¤Í
¾Ç¨ì¦Ñ¦º
·í«eÂ÷½u
UID
21792
©«¤l
44
¥DÃD
14
ºëµØ
0
¿n¤À
58
ª÷¿ú
58
ÂI¦W
0
§@·~¨t²Î
Window 8
³nÅ骩¥»
2010
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
15 ¤p®É
µù¥U®É¶¡
2015-8-15
³Ì«áµn¿ý
2017-4-18
¤¤¾Ç¥Í
©«¤l
44
¥DÃD
14
ºëµØ
0
¿n¤À
58
ÂI¦W
0
§@·~¨t²Î
Window 8
³nÅ骩¥»
2010
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2015-8-15
³Ì«áµn¿ý
2017-4-18
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2015-11-14 14:52
|
¥u¬Ý¸Ó§@ªÌ
¦a°Ï§Oªº¶i³f¼Æ¶q¥[Á`
¦U¦ì¤j¤j¦n¡A¥H¤U¬O§Ú³]©wªºÀx¦s®æ°Ñ·Ó¡A§Ú·Qn±N»´ä¸ò¥xÆW¦a°Ïªº²£«~§OÓ§O²Îp¡A¦bÁÙ¨S¤À¦a°Ï§O®É¡A§Ú¥i¥H¥Î¨ç¼ÆSUMIF°µ²£«~§Oªºpºâ¥[Á`¡A
¦ý¬O¥[¤J¦a°Ï§O«á¡A§Ú¦³·Q¹L¥ÎIF¥h§P§O¥xÆW©Î¬O»´ä¡A¦A°µSUMIF¡A¦ý¬O...¨ç¼Æ«Ü©Ç¡A¨D¸Ñ~.~ ÁÂÁ¦U¦ì
¦a°Ï ²£«~ ¶i³f¼Æ¶q
¥xÆW TCL 999
»´ä ³Ðºû 3000
¥xÆW ªø¬õ 400
»´ä ³Ðºû 100
»´ä TCL 500
»´ä ªø¬õ 600
¥xÆW ³Ðºû 700
¥xÆW TCL 300
¥xÆW ªø¬õ 100
¼Ó¥D¼ö©«
Ãö©ó¼g¥¨¶°µ{¦¡¦Û°Ê¿z¿ï§PÂ_°Ïªº¥N½X½Æ»s¦¨
Activate»POpenªº®t§O¸òWindowsªº©w¸q
¤å¦r±ø¥ó¦ê±µ½Ð¯q
Â^¨ú¯S©w¦r¦ê¨Ã¥ÎȪí¹F¤À¨É¨Ã½Ð¯q
¤å¦r¦ê±µ»yªk²¤Æ¤Î©µ¦ù½Ð¯q
¤é´Á¨ç¼Æ¬ÛÃö°ÝÃD
Ãö©óget.workbookªº¨î
ExcelÀÉÂàTXTÀɮתº¬ÛÃö¨ç¼Æ¸Ñ´b
±q¨ä¥LexcelÀɮװŶK¦Ü«ü©w°Ï°ì
¥æ¤e¹Bºâªº¨Ò¤l
¦¬ÂÃ
¤À¨É
¾Ç¨ì¦Ñ¦º
µoµu®ø®§
¥[¬°¦n¤Í
¾Ç¨ì¦Ñ¦º
·í«eÂ÷½u
UID
21792
©«¤l
44
¥DÃD
14
ºëµØ
0
¿n¤À
58
ª÷¿ú
58
ÂI¦W
0
§@·~¨t²Î
Window 8
³nÅ骩¥»
2010
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
15 ¤p®É
µù¥U®É¶¡
2015-8-15
³Ì«áµn¿ý
2017-4-18
¤¤¾Ç¥Í
©«¤l
44
¥DÃD
14
ºëµØ
0
¿n¤À
58
ÂI¦W
0
§@·~¨t²Î
Window 8
³nÅ骩¥»
2010
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2015-8-15
³Ì«áµn¿ý
2017-4-18
2
#
µoªí©ó 2015-11-14 14:54
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ ¾Ç¨ì¦Ñ¦º ©ó 2015-11-14 14:56 ½s¿è
§Úª¾¹D¼Ï¯Ã¤ÀªRªí¥i¥H»´©ö§¹¦¨¡A¦ý¬O§Ú³]©wªºÀx¦s®æ°Ñ·Ó¬O¥i¥Hקï¡A¦Ó¥[Á`Äd¬O§Y®É§@³s°Êªº¡C
¥Ø«e§Ú±oª¾YÀx¦s®æ°Ñ·Óªº¤º®eקï¡A¼Ï¯Ã¤ÀªRªí»Ýn¦A«·s§ì¨ú¡AÁÙ¬O¦³¥t¥~¤è¦¡¡A¥i¥HÅý¼Ï¯Ã¤ÀªRªí§Y®É§ó·s©O?
TOP
hcm19522
µoµu®ø®§
¥[¬°¦n¤Í
hcm19522
·í«eÂ÷½u
UID
22069
©«¤l
1391
¥DÃD
4
ºëµØ
0
¿n¤À
1401
ª÷¿ú
1401
ÂI¦W
0
§@·~¨t²Î
WIN
³nÅ骩¥»
2007
¾\ŪÅv
50
©Ê§O
¨k
¦b½u®É¶¡
1755 ¤p®É
µù¥U®É¶¡
2015-9-11
³Ì«áµn¿ý
2024-12-16
¤j¾Ç¥Í
©«¤l
1391
¥DÃD
4
ºëµØ
0
¿n¤À
1401
ÂI¦W
0
§@·~¨t²Î
WIN
³nÅ骩¥»
2007
¾\ŪÅv
50
©Ê§O
¨k
µù¥U®É¶¡
2015-9-11
³Ì«áµn¿ý
2024-12-16
3
#
µoªí©ó 2015-11-14 16:04
|
¥u¬Ý¸Ó§@ªÌ
http://blog.xuite.net/hcm19522/twblog/356868953
SUMIFS($C$2:$C$99,$A$2:$A$99,$E2,$B$2:$B$99,F$1)
TOP
ÀR«ä¦Û¦b :
¥@¤W¦³¨â¥ó¨Æ¤£¯àµ¥¡G¤@¡B§µ¶¶ ¤G¡B¦æµ½¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·