µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excel£¸¯ë°Ï
» SUMPRODUCT§ï¼g¦¨SUMIFS¤è¦¡
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
SUMPRODUCT§ï¼g¦¨SUMIFS¤è¦¡
maxchou
µoµu®ø®§
¥[¬°¦n¤Í
maxchou
·í«eÂ÷½u
UID
6096
©«¤l
40
¥DÃD
9
ºëµØ
0
¿n¤À
72
ª÷¿ú
72
ÂI¦W
0
§@·~¨t²Î
xp
³nÅ骩¥»
office 2010
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
69 ¤p®É
µù¥U®É¶¡
2011-8-19
³Ì«áµn¿ý
2024-10-28
¤¤¾Ç¥Í
©«¤l
40
¥DÃD
9
ºëµØ
0
¿n¤À
72
ÂI¦W
0
§@·~¨t²Î
xp
³nÅ骩¥»
office 2010
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2011-8-19
³Ì«áµn¿ý
2024-10-28
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2019-10-21 16:54
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
SUMPRODUCT§ï¼g¦¨SUMIFS¤è¦¡
¤j®a¦n¡G
ì¨Ï¥ÎSUMPRODUCT¡A¦ýÀHµÛ¼Æ¾Ú¼Æ¶q¶V¨Ó¶V¤j¡AEXCEL¶]±o«ÜºC¡Agoogleµo²{»¡SUMIFS·|¤ñ¸û§Ö¡A©Ò¥H·Q§ï¼g¦¨SUMIFS¡A¦ý¤@ª½µLªk¦¨¥\¡C
¥Î²³æ½d¨Ò»¡©ú¦pªþ¥ó¡Aì©l¸ê®Æªºcolumn¦³¥]§t¦~«×¡A§Ú·Q¾ã²z¦¨ªº®æ¦¡¡A¬O·|®Ú¾Ú·Qnªº¦~«×¥h§ì¨ú(Àx¦s®æM1 N1§Ú¥i¥HÀH®É§ï¦¨§Ú·Qnªº¦~«×)¡A
©Ò¥H¥ÎSUMPRODUCT¥i¥H¥Îcolumnªº¦~«×·í¦¨±ø¥ó¡A¦ýSUMIFS¦n¹³¤£¯à§âcolumnªº¦~«×·í¦¨±ø¥ó¡C
·Q½Ð±Ð¦U¦ì¤j®v¡A¦³¿ìªk¥ÎSUMIFS¨Ó¹F¦¨§Úªº»Ý¨D¶Ü¡H
¦b¦¹¥ýÁ¹L!!
°ÝÃD.zip
(7.39 KB)
¤U¸ü¦¸¼Æ: 7
2019-10-21 16:47
¼Ó¥D¼ö©«
½Ð°Ý³oºØ¶¥±è¹Ï¦³¿ìªk¥ÎEXCLEµe¥X¨Ó¶Ü¡H
½u©Ê¤º´¡Èªº¤½¦¡
µ§¼Æ¤£¦P¡A¦p¦ó¥[Á`¡H
Excel¹Ïªí¤¤ªº¤å¦r¤è¶ô¦³¥i¯à»PÀx¦s®æ¼Æ¾Ú³s
¦WºÙ¨Ï¥Î°ÊºA½d³òªº°ÝÃD
½Ð°Ý¥ÎEXECLµe´²§G¹Ï
·Q®Ú¾ÚAÄ椺®eÂà´«¦¨BÄæ
¸ê®Æ¾ã²zªº¤½¦¡
¦¬ÂÃ
¤À¨É
handmuch
µoµu®ø®§
¥[¬°¦n¤Í
handmuch
(expresmile)
·í«eÂ÷½u
UID
3197
©«¤l
43
¥DÃD
1
ºëµØ
0
¿n¤À
74
ª÷¿ú
74
ÂI¦W
0
§@·~¨t²Î
windows 7
³nÅ骩¥»
office 2007
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
30 ¤p®É
µù¥U®É¶¡
2011-1-17
³Ì«áµn¿ý
2020-8-24
¡@¼ÊºÙ:
expresmile
¤¤¾Ç¥Í
©«¤l
43
¥DÃD
1
ºëµØ
0
¿n¤À
74
ÂI¦W
0
§@·~¨t²Î
windows 7
³nÅ骩¥»
office 2007
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2011-1-17
³Ì«áµn¿ý
2020-8-24
2
#
µoªí©ó 2019-10-23 09:57
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ handmuch ©ó 2019-10-23 09:58 ½s¿è
SUMIFS(OFFSET($B$1,1,MATCH(M$1,$C$1:$H$1,0),7,1),$A$2:$A$8,$K2,$B$2:$B$8,$L2)
http://expresmile.teachable.com
TOP
zz5151353
µoµu®ø®§
¥[¬°¦n¤Í
zz5151353
·í«eÂ÷½u
UID
218
©«¤l
206
¥DÃD
3
ºëµØ
0
¿n¤À
218
ª÷¿ú
218
ÂI¦W
0
§@·~¨t²Î
WIN10
³nÅ骩¥»
OFFICE 365
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¥xÆW¥x¥_
¦b½u®É¶¡
137 ¤p®É
µù¥U®É¶¡
2010-5-15
³Ì«áµn¿ý
2023-6-18
ª©¥D
©«¤l
206
¥DÃD
3
ºëµØ
0
¿n¤À
218
ÂI¦W
0
§@·~¨t²Î
WIN10
³nÅ骩¥»
OFFICE 365
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¥xÆW¥x¥_
µù¥U®É¶¡
2010-5-15
³Ì«áµn¿ý
2023-6-18
3
#
µoªí©ó 2019-12-31 10:36
|
¥u¬Ý¸Ó§@ªÌ
[i=s] ¥»©«³Ì«á¥Ñ zz5151353 ©ó 2019-12-31 10:39 ½s¿è [/i]
M2
=SUMIFS(OFFSET($C:$C,,MATCH(M$1,$C$1:$H$1,)-1,,),$A:$A,$K2,$B:$B,$L2)
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
TOP
ÀR«ä¦Û¦b :
«Ý¤H°h¤@¨B¡A·R¤H¼e¤@¤o¡A´N·|¬¡±o«Ü§Ö¼Ö¡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¯»µ·