SUMPRODUCTµLªk§P§O??*¸U¥Î¦r¤¸¶Ü
- ©«¤l
- 18
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 26
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2013-6-17
- ³Ì«áµn¿ý
- 2020-6-20
|
SUMPRODUCTµLªk§P§O??*¸U¥Î¦r¤¸¶Ü
¦p¤W¹Ï ·Q¼g¤J¤½¦¡ªº¬O¦³¦â¶ôªºÀx¦s®æ
K.L.Mªº7.8.9¹ïÀ³ªº¬OAÄ檺¤W¥«¤é´Á
IÄæ¤U¤èªº´Ú¦¡§O¬O¹ïÀ³BÄæ³f¸¹¿z¿ï¥Xªº
(BÄ檺®æ¦¡¬°¤å¦r)
·Q²Îp²Å¦X¦U¤ë¥÷¸Ì¦U´Ú¦¡ªºÁ`ª÷ÃB
JÄ檺¤½¦¡¬°=COUNTIF(B:B,"??11*")±o¥X¨Óªº¼Æ¨S°ÝÃD
¦ýK5 ¶ñ¤Jªº¤½¦¡¬°=SUMPRODUCT(($A$4:$A$17=7)*($B$4:$B$17="??11*"),$G$4:$G$17)®É¼ÆÈ«o¬°0
·Q½Ð±Ð¥H¤W¼gªº¤½¦¡¬Oþ¸Ì¥X¿ù¤F
ÁÙ¬O¦³¨ä¥L¤è¦¡©Î¤½¦¡¥i¸Ñ¨M
PS.¥ÎSUMIFS´N¥i§PŪ§t¸U¥Î¦r¦ê
¦]¬°¤½¥q¥Îªº¬O2003ª©ªº ©Ò¥HµLªk¨Ï¥Î¸Ó¨ç¼Æ
¥ÎSUMIFS´N¥i§PŪ§t¸U¥Î¦r¦ê |
|
|
|
|
|
|
- ©«¤l
- 186
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 218
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-11-12
- ³Ì«áµn¿ý
- 2014-4-15
|
¦^´_ 1# joey3277
¦pªG¤@©wn¥Î¸U¥Î¦r¤¸ªº¸Ü¥i§ï¬°- ISNUMBER(1/(SEARCH("??11*",$B$4:$B$17)=1))
½Æ»s¥N½X ì²z¡G
SEARCH¥i¨Ï¥Î¸U¥Î¦r¤¸ ¦]¦¹SEARCHªºªF¦è¦pªG¬O¦b²Ä¤@Ó¡A«h²Å¦X쥻·Q¨Ï¥Îªº¸U¥Î¦r¤¸
¦ý¬OSEARCH¤£¨ìªº³£·|¬O#VALUE!¿ù»~¡A¤£µ¥©ó1ªº·|¬OFALSE¡Aµ¥©ó1ªº¬OTRUE
¦A¨ú˼ơA¦]¦¹FALSEªº·|Åܦ¨DIV!0¿ù»~¡ATRUEªº´NÅܦ¨1¡A¦]¦¹¥~±¦A¥]¤@¼hISNUMBER¡A´N¥u¦³SEARCH("??11*",$B$4:$B$17)=1ªº·|¬OTRUE¡A¨ä¾l³£¬OFALSE
¬O»¡³oÓªF¦è¥»¨Ó´N·|¬O0¡A¦]¬°µ¥©ó7¥B¬O"??11*"ªº¸ò¥»´N¤£¦s¦b°Ú
§A¥»¨ªº»Ý¨D§Ú¨ä¹ê¬Ý¤£¤ÓÀ´¡K¡K¨ì©³§A¾ãÓªí¬Onºâ¤°»ò¡H |
|
|
|
|
|
|
- ©«¤l
- 18
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 26
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2013-6-17
- ³Ì«áµn¿ý
- 2020-6-20
|
·PÁ Bodhidharma ¤j¤jªº¦^ÂÐ
°ÝÃD²×©ó¸Ñ¨M¤F
³o±iªí¦³¨º»òÃø¬Ý¥X¨Ónºâ¤°»ò¶Ü:L
¥ªÃä¬O¤½¥q¨î¦¡ªº®æ¦¡
¥kÃ䪺³¡¥÷ ¬Onpºâ"¨CÓ¤ë""¨CºØÃþ§O"°Ó«~ªº(´Ú¼Æ)»P(Á`¼Æ¶q)
¸ò§Ú¤W¤@¦U°ÝÃD"¦X¨ÖÀx¦s®æµLªkpºâ¥[Á`"
nºâªºªF¦è¬O¤@¼Ëªº
¥u¬Oªí®æ§Î¦¡¤£¦P :L ¤SµLªk§ó§ï |
|
|
|
|
|
|