µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excel£¸¯ë°Ï
» ½Ð±Ð¦h¼Æªí®æ¿z¿ï¥[Á`ªº¼gªk×¥¿°ÝÃD?
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
½Ð±Ð¦h¼Æªí®æ¿z¿ï¥[Á`ªº¼gªk×¥¿°ÝÃD?
hairyhead
µoµu®ø®§
¥[¬°¦n¤Í
hairyhead
·í«eÂ÷½u
UID
22883
©«¤l
12
¥DÃD
6
ºëµØ
0
¿n¤À
18
ª÷¿ú
18
ÂI¦W
0
§@·~¨t²Î
Win10
³nÅ骩¥»
Office2003
¾\ŪÅv
10
©Ê§O
¨k
¦b½u®É¶¡
2 ¤p®É
µù¥U®É¶¡
2015-12-4
³Ì«áµn¿ý
2016-10-8
¤p¾Ç¥Í
©«¤l
12
¥DÃD
6
ºëµØ
0
¿n¤À
18
ÂI¦W
0
§@·~¨t²Î
Win10
³nÅ骩¥»
Office2003
¾\ŪÅv
10
©Ê§O
¨k
µù¥U®É¶¡
2015-12-4
³Ì«áµn¿ý
2016-10-8
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2016-1-12 10:19
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
½Ð±Ð¦h¼Æªí®æ¿z¿ï¥[Á`ªº¼gªk×¥¿°ÝÃD?
½Ð°Ý¦U¦ì
¦]¬°³Ìªñ¦³¼g¤F¤@ÓÀÉ®×
=SUMIF('T-1'!I9:I218,"ªù¥«*",'T-1'!G9:G218)
¸Ì±¦³T-1¤u§@ªí¦ÜT-12¤u§@ªí
¦@12±i¤u§@ªí
·Q½Ð³oÓn«ç»òקï§Ë¤ñ¸û¦n©O? ÁÂÁÂ
=SUMIF(
'T-1:T-12'
!I9:I218,"ªù¥«*",
'T-1:T-12'
!G9:G218)
§Ú§ï¦¨³o¼ËEXCEL·|§PÂ_¿ù»~...
¼Ó¥D¼ö©«
ìF©óIF¦h±ø¥ó¥Îªk¤½¦¡
½Ð±ÐÃö©ó¦C¦L½d³ò°ÝÃD(Àx¦s®æ¨S¦³¸ê®Æ¤£¦C¦L
½Ð±Ð§ì¨ú¤£¦PEXCELÀÉ®×°µ²M³æ°ÝÃD?
½Ð±ÐÃö©ó¿z¿ï¤£«ü©wÄæ¦ìªº¤½¦¡¼gªk?
Ãö©ó»s§@ª½±ø¹Ï°ÝÃD (2Óªí®æ¥H¤W)
¦¬ÂÃ
¤À¨É
rouber590324
µoµu®ø®§
¥[¬°¦n¤Í
rouber590324
·í«eÂ÷½u
UID
18546
©«¤l
561
¥DÃD
160
ºëµØ
0
¿n¤À
725
ª÷¿ú
725
ÂI¦W
0
§@·~¨t²Î
WINDOWS
³nÅ骩¥»
xp
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
®ç¶é
¦b½u®É¶¡
557 ¤p®É
µù¥U®É¶¡
2014-9-10
³Ì«áµn¿ý
2024-8-7
°ª¤¤¥Í
©«¤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
2
#
µoªí©ó 2016-1-12 16:36
|
¥u¬Ý¸Ó§@ªÌ
SUMIF('T-1'!I9:I218,"ªù¥«*",'T-1'!G9:G218)+SUMIF('T-2'!I9:I218,"ªù¥«*",'T-2'!G9:G218)+....+SUMIF('T-12'!I9:I218,"ªù¥«*",'T-12'!G9:G218)
ù
TOP
ã´£³¡ªL
µoµu®ø®§
¥[¬°¦n¤Í
ã´£³¡ªL
·í«eÂ÷½u
UID
13768
©«¤l
2833
¥DÃD
10
ºëµØ
0
¿n¤À
2889
ª÷¿ú
2889
ÂI¦W
0
§@·~¨t²Î
¡e²¤¡f
³nÅ骩¥»
¡e²¤¡f
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¡e²¤¡f
¦b½u®É¶¡
2106 ¤p®É
µù¥U®É¶¡
2013-5-13
³Ì«áµn¿ý
2024-11-12
ª©¥D
©«¤l
2833
¥DÃD
10
ºëµØ
0
¿n¤À
2889
ÂI¦W
0
§@·~¨t²Î
¡e²¤¡f
³nÅ骩¥»
¡e²¤¡f
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¡e²¤¡f
µù¥U®É¶¡
2013-5-13
³Ì«áµn¿ý
2024-11-12
3
#
µoªí©ó 2016-1-13 12:48
|
¥u¬Ý¸Ó§@ªÌ
=SUMPRODUCT(SUMIF(INDIRECT("'T-"&ROW($1:$12)&"'!I9:I218"),"ªù¥«*",INDIRECT("'T-"&ROW($1:$12)&"'!G9:G218")))
TOP
hairyhead
µoµu®ø®§
¥[¬°¦n¤Í
hairyhead
·í«eÂ÷½u
UID
22883
©«¤l
12
¥DÃD
6
ºëµØ
0
¿n¤À
18
ª÷¿ú
18
ÂI¦W
0
§@·~¨t²Î
Win10
³nÅ骩¥»
Office2003
¾\ŪÅv
10
©Ê§O
¨k
¦b½u®É¶¡
2 ¤p®É
µù¥U®É¶¡
2015-12-4
³Ì«áµn¿ý
2016-10-8
¤p¾Ç¥Í
©«¤l
12
¥DÃD
6
ºëµØ
0
¿n¤À
18
ÂI¦W
0
§@·~¨t²Î
Win10
³nÅ骩¥»
Office2003
¾\ŪÅv
10
©Ê§O
¨k
µù¥U®É¶¡
2015-12-4
³Ì«áµn¿ý
2016-10-8
4
#
µoªí©ó 2016-1-14 18:16
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
3#
ã´£³¡ªL
·PÁÂ
³oºØ¼gªk¤ñ쥻T-1 .... + T12ÁYµu«Ü¦h¤ñ¸û®e©ö¬Ý±o²M·¡
TOP
ÀR«ä¦Û¦b :
µêªÅ¦³ºÉ¡D§ÚÄ@µL½a¡AµoÄ@®e©ö¦æÄ@Ãø¡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¯»µ·