µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excel£¸¯ë°Ï
» À³¸Ó¬O¥Î sumif ?
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
À³¸Ó¬O¥Î sumif ?
eg0802
µoµu®ø®§
¥[¬°¦n¤Í
eg0802
·í«eÂ÷½u
UID
8442
©«¤l
81
¥DÃD
26
ºëµØ
0
¿n¤À
106
ª÷¿ú
106
ÂI¦W
0
§@·~¨t²Î
WIN7
³nÅ骩¥»
32¦ì¤¸
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
¥xÆW
¦b½u®É¶¡
34 ¤p®É
µù¥U®É¶¡
2012-3-3
³Ì«áµn¿ý
2019-6-26
¤¤¾Ç¥Í
©«¤l
81
¥DÃD
26
ºëµØ
0
¿n¤À
106
ÂI¦W
0
§@·~¨t²Î
WIN7
³nÅ骩¥»
32¦ì¤¸
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
¥xÆW
µù¥U®É¶¡
2012-3-3
³Ì«áµn¿ý
2019-6-26
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2013-7-10 15:59
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
À³¸Ó¬O¥Î sumif ?
½d¨Ò.rar
(6.49 KB)
¤U¸ü¦¸¼Æ: 9
2013-7-10 15:59
¦pªþ¥ó Àµ½Ð¤j¤jÀ°¦£~~ ¤p§Ì¥Îsumif ±o¥Xµ²ªG¬O0...
¼Ó¥D¼ö©«
¥u¶K¤W¥i¨£Àx¦s®æ??
EXCEL ÀɮצX¨Ö
§R°£ªÅ¥ÕÀx¦s®æ¤@¾ã¦C
¤@¦¸¼W¥[ªÅ¥Õ¦C~~¨D±Ï!!
¤½¦¡ÅçÃÒ~¨D±Ï!!!
¥[Á`°ÝÃD!!! ¨D±Ï~~~
¦V¤U½Æ»s "¦pªGªÅ¥Õ´N°Ñ·Ó¤W±ªºÈ¡A¨S¦³
¥u²¾°£«½Æ"È"
¸ê®Æ¤ñ¹ï~~¨D±Ï!!
½Æ»s¥B¦Û°Ê°Ñ·Ó¬YÄæ¶K¤W
¦¬ÂÃ
¤À¨É
Jason
sunnyso
µoµu®ø®§
¥[¬°¦n¤Í
sunnyso
·í«eÂ÷½u
UID
13329
©«¤l
605
¥DÃD
92
ºëµØ
0
¿n¤À
648
ª÷¿ú
648
ÂI¦W
0
§@·~¨t²Î
windows
³nÅ骩¥»
7
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
macau
¦b½u®É¶¡
409 ¤p®É
µù¥U®É¶¡
2013-4-5
³Ì«áµn¿ý
2019-2-10
°ª¤¤¥Í
©«¤l
605
¥DÃD
92
ºëµØ
0
¿n¤À
648
ÂI¦W
0
§@·~¨t²Î
windows
³nÅ骩¥»
7
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
macau
µù¥U®É¶¡
2013-4-5
³Ì«áµn¿ý
2019-2-10
2
#
µoªí©ó 2013-7-10 16:35
|
¥u¬Ý¸Ó§@ªÌ
I5=SUMIF($C$5:$C$23,$H5,$D$5:$D$23)
½Æ»s¥N½X
ss
TOP
ML089
µoµu®ø®§
¥[¬°¦n¤Í
ML089
·í«eÂ÷½u
UID
3671
©«¤l
2025
¥DÃD
13
ºëµØ
0
¿n¤À
2053
ª÷¿ú
2053
ÂI¦W
0
§@·~¨t²Î
WIN7
³nÅ骩¥»
Office2007
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¥x¥_¥«
¦b½u®É¶¡
2405 ¤p®É
µù¥U®É¶¡
2011-3-2
³Ì«áµn¿ý
2024-3-14
ª©¥D
©«¤l
2025
¥DÃD
13
ºëµØ
0
¿n¤À
2053
ÂI¦W
0
§@·~¨t²Î
WIN7
³nÅ骩¥»
Office2007
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¥x¥_¥«
µù¥U®É¶¡
2011-3-2
³Ì«áµn¿ý
2024-3-14
3
#
µoªí©ó 2013-7-10 17:06
|
¥u¬Ý¸Ó§@ªÌ
I5=SUMIF(C:C,H5,D:D)
½Æ»s¥N½X
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
TOP
ÀR«ä¦Û¦b :
§g¤l¦p¤ô¡AÀH¤è´N¶ê¡AµL³B¤£¦Û¦b¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
Excelµ{¦¡°Ï
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¯»µ·