½Ð°ÝÁ`©M¸Ó¤ë¥÷ª÷ÃB¡A¥HSUMIFS¬°¦ó·|¿ù»~?
- ©«¤l
- 233
- ¥DÃD
- 53
- ºëµØ
- 0
- ¿n¤À
- 292
- ÂI¦W
- 0
- §@·~¨t²Î
- WinXp
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-1-6
- ³Ì«áµn¿ý
- 2024-3-8
|
½Ð°ÝÁ`©M¸Ó¤ë¥÷ª÷ÃB¡A¥HSUMIFS¬°¦ó·|¿ù»~?
A¡B¤é´Á
B¡Bª÷ÃB
A1:A300=1¤ë16¤é~12¤ë12¤é(¤£©w)
A=¦³ªÅ¥ÕÄæ¦ì(Äæ¦ì¤£©w)
¦]¬°¥HMONTH¡A·|±NªÅ¥ÕÄæ¦ìºâ¦¨¬°1
©Ò¥H¥t¥[¤WCÄæpºâ¤ë¥÷=if(LEN(A1)>0,MONTH(A1),"")
¥H11¤ë¥÷ªí¥Ü
D1=SUMIFS(A3:A300,11,B3:B300)
¦ý¬O«o¥X²{¤½¦¡¿ù»~¡F½Ð°Ý¬OþÓÀô¸`¦³¿ù»~©O?
¥t¥~¡A¥i¥H¤£»Ýn¦A¨Ï¥ÎCÄæ¦ì¡Aª½±µpºâ¥XBÄæ¦ìªºª÷ÃB´N¥i¥H¤F¶Ü? |
|
|
|
|
|
|
- ©«¤l
- 94
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 114
- ÂI¦W
- 0
- §@·~¨t²Î
- win 7
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2012-10-17
- ³Ì«áµn¿ý
- 2014-1-3
|
¦^´_ 1# jackson7015
§â§Aµ{¦¡§ï¬° °O±o¥[¤Wµ´¹ï¦ì¸m ¥H§K½Æ»s¨ì§OªºÄæ¦ì·|§ïÅÜC2:C300ªº½d³ò
=SUMIF($C$2:$C$300,11,$B$2:$B$300) ¬õ¦â³¡¤À½Ð¦Û¦æ§ï¤ë¥÷
¥ý¸Ñ¨M±z²Ä¤@Ó°ÝÃD ¦]¬°¦pªGn¬Ù²¤CÄæ ¥i¯à»Ýn¨Ï¥ÎVBA¤~¦³¿ìªk |
|
¦Û¥Î¨®¤]¥i¥Hñ±b³á!
¤¤d¤¸¥[ªoª÷¥[¤Jªo½c«áÁÙ¦^õX±z6200¤¸
ºÖ§Q©ô¨®¤Í·|power-want.com
|
|
|
|
|
- ©«¤l
- 233
- ¥DÃD
- 53
- ºëµØ
- 0
- ¿n¤À
- 292
- ÂI¦W
- 0
- §@·~¨t²Î
- WinXp
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-1-6
- ³Ì«áµn¿ý
- 2024-3-8
|
¦^´_ 2# die78325
©êºp¡A§Úªº¤º¤å¥´¿ù¤F
§Ú쥻¼gªº¤½¦¡´N¬OD1=SUMIF(C2:C300,11,B2:B300)
¥u¬O¨S¦³µ´¹ï¦ì§}¦Ó¤w¡A¦¤W½s¼gªº®ÉÔ³£·|¥X²{¿ù»~
¦ý¬O²{¦b¤S¯à¥¿±`°õ¦æ¤F
쥻¥H¬°¥i¥H±NCÄ檺¤½¦¡¡Aµ²¦XD1¤½¦¡¨Ó°µ¹Bºâ
¬Ý¨ÓÁÙ¬On¦h¤@Äæ¦ì¨Ó¹B§@¤F
·PÁÂÀ°¦£! |
|
|
|
|
|
|
- ©«¤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
|
¨þ¨þ
´£¨Ñªº¤½¦¡ D1=SUMIFS(A3:A300,11,B3:B300) ¥Îªk¬O SUMIF¤èªk
SUMIFS ¬OOFFICE 2007 ¥H¤Wªºª©¥»
SUMIF ¬O 2003 ¥H¤Uªºª©¥» |
|
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|