µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excel£¸¯ë°Ï
» ¦p¦ó²Îp¤H¼Æ¦~ÄÖ?
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
¦p¦ó²Îp¤H¼Æ¦~ÄÖ?
kkooo15
µoµu®ø®§
¥[¬°¦n¤Í
kkooo15
(·s¤â)
·í«eÂ÷½u
UID
7049
©«¤l
123
¥DÃD
37
ºëµØ
0
¿n¤À
177
ª÷¿ú
177
ÂI¦W
0
§@·~¨t²Î
WIN10
³nÅ骩¥»
Office 2010
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
¥x¥_
¦b½u®É¶¡
166 ¤p®É
µù¥U®É¶¡
2011-11-9
³Ì«áµn¿ý
2024-3-28
¡@¼ÊºÙ:
·s¤â
¤¤¾Ç¥Í
©«¤l
123
¥DÃD
37
ºëµØ
0
¿n¤À
177
ÂI¦W
0
§@·~¨t²Î
WIN10
³nÅ骩¥»
Office 2010
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
¥x¥_
µù¥U®É¶¡
2011-11-9
³Ì«áµn¿ý
2024-3-28
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2013-1-16 01:01
|
Åã¥Ü¥þ³¡©«¤l
¦p¦ó²Îp¤H¼Æ¦~ÄÖ?
¦p¦ó²Îp¤H¼Æ¦~ÄÖ?
¤u§@ªí1
¤U¸ü
(84.43 KB)
2013-1-16 00:59
¤u§@ªí2
¤U¸ü
(65.48 KB)
2013-1-16 00:59
¤u§@ªí¤@n¦p¦ó²Îp¤H¼Æ¨ì¤u§@ªí¤G
PS.¸ê®Æ·|¤@ª½¼W¥[
³Â·Ð«e½úÀ°¦£
test.rar
(34.8 KB)
¤U¸ü¦¸¼Æ:7
2013-1-16 00:56
¼Ó¥D¼ö©«
µ|¤º¡Bµ|¥~«ç»òºâ
²{¦b¬Ý¤CÀs¯]ªº¤H¡A³£¨S¦³¬Ý¹L³o¥x¨®?
³æ®æ¦³¤å¦r¤¤ªº¼Æ¦r¥[Á`
¦p¦ó¦b®Ö¨ú¤è¶ô ½Æ¿ï«á¦b¦P¤@Äæ±o¨ì½Æ¿ïªºÈ
½Ð°Ý®æ¦¡¤Æ±ø¥ó+¨ç¼Æ
½s¸¹¤è¦¡-^¤å+¦~¤ë+¬y¤ô½s¸¹2½X.¥X¨Ó¨S«ö¶¶
·Q´îµu¤½¦¡
¿ï¾ÜListBox¤º¸ê®Æ¦p¦ó©ñ¨ì¨ä¥LUserFormªºT
¥t¦s·sÀÉ «ç»ò§âÄæ寛¸ò¦C°ª¤]½Æ»s¨ì·s
¤j¼Ó¦@¤½°òª÷¸Õºâ
¦¬ÂÃ
¤À¨É
excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA
kkooo15
µoµu®ø®§
¥[¬°¦n¤Í
kkooo15
(·s¤â)
·í«eÂ÷½u
UID
7049
©«¤l
123
¥DÃD
37
ºëµØ
0
¿n¤À
177
ª÷¿ú
177
ÂI¦W
0
§@·~¨t²Î
WIN10
³nÅ骩¥»
Office 2010
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
¥x¥_
¦b½u®É¶¡
166 ¤p®É
µù¥U®É¶¡
2011-11-9
³Ì«áµn¿ý
2024-3-28
¡@¼ÊºÙ:
·s¤â
¤¤¾Ç¥Í
©«¤l
123
¥DÃD
37
ºëµØ
0
¿n¤À
177
ÂI¦W
0
§@·~¨t²Î
WIN10
³nÅ骩¥»
Office 2010
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
¥x¥_
µù¥U®É¶¡
2011-11-9
³Ì«áµn¿ý
2024-3-28
2
#
µoªí©ó 2013-1-16 09:47
|
Åã¥Ü¥þ³¡©«¤l
ÁÂÁ«e½ú¨º»ò§Ö´N¦^´_
À°¤F§Ú¤@Ó¤j¦£!!
§Ú¤Wºô¬d¤F¤@¤USUMIF¨ç¼Æ¤u¯à!!
¤@¡B ¥\¯àpºâ¸ê®Æ½d³ò¤¤²Å¦X±ø¥ó¤§¸ê®Æ¡A»P¨ä©Ò°t¹ï¤§¥[Á`¸ê®ÆªºÁ`©M
¤G¡B »yªkSUMIF(¸ê®Æ½d³ò¡A·Ç«h±ø¥ó¡A¹ê»Ú¥[Á`¸ê®Æªº½d³ò)
¡° ·Ç«h±ø¥óªº«¬¦¡¥i¥H¬O¼Æ¦r¡B¤å¦r©Îªí¥Ü¦¡
¤T¡B ½d¨Ò
-----------------------------------------------------------------------------
pºâ¤£¤Î®æ¬ì¥Ø¼Æ¡B¾Ç¤À¼Æ(¡u¨ç¼Æ.xls¡vªº¡uSUMIF(1)¡v¤u§@ªí)
l pºâ¤£¤Î®æ¬ì¥Ø¼Æ¡G H4ªº¤½¦¡ ¡÷ =COUNTIF(C4¡GG4,"<60")®æ¦¡ ¡÷ 0 "¬ì"
l pºâ¤£¤Î®æ¾Ç¤À¼Æ I4ªº¤½¦¡=SUMIF(C4¡GG4,"<60"$C$2)¡G$C$2¡G$G$2)®æ¦¡ ¡÷ 0 "¾Ç¤À"
excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA
TOP
ÀR«ä¦Û¦b :
¹ï¤÷¥Ànª¾®¦¡A·P®¦¡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¯»µ·