(¤w¸Ñ¨M)½Ð°Ý¦p¦ó²Îp¤£¦P°Ï¶¡ªº³Ì¤j¼Æ¥Ø?
- ©«¤l
- 586
- ¥DÃD
- 123
- ºëµØ
- 0
- ¿n¤À
- 763
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOW7
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-16
- ³Ì«áµn¿ý
- 2017-3-14
|
(¤w¸Ñ¨M)½Ð°Ý¦p¦ó²Îp¤£¦P°Ï¶¡ªº³Ì¤j¼Æ¥Ø?
¥»©«³Ì«á¥Ñ freeffly ©ó 2012-2-22 17:10 ½s¿è
§Ú·Qnª¾¹DBÄæ¨C¤@Ó³sÄò¼Æ¦rªº³Ì¤@«á¦U¬O¦h¤Ö ¥BÁ`¦@¥X²{´X¬q¼Æ¦r
°²³]¸ê®Æ¥u¨ì80¦C
«h¥X²{4¬q¼Æ¦r ³Ì«á¤@ӼƤÀ§O12 3 8 2 ³o¥|ӼƦr
¤£ª¾¹D³oºØ¸ê°T¦³¨S¦³¤ñ¸û¦nªº¤è¬O¨D±o
¥Ø«e§Ú¥u·Q¨ìCOUNTIFªº¤è¦¡¦Ó¥BÁÙ¨S±o¨ì³Ì«áµª®×
½Ð°ª¤â¨ó§U¤@¤U
Book1.rar (31.59 KB)
|
|
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ
|
|
|
|
|
- ©«¤l
- 586
- ¥DÃD
- 123
- ºëµØ
- 0
- ¿n¤À
- 763
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOW7
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-16
- ³Ì«áµn¿ý
- 2017-3-14
|
¦^´_ 2# Hsieh
ÁÂÁª©¥D
³o¬O§Únªºµª®×
¬Ý¨Ó¤Sn¦A«×¤À¸Ñ¤½¦¡¬ã¨s¬ã¨s
·P®¦ |
|
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ
|
|
|
|
|
- ©«¤l
- 586
- ¥DÃD
- 123
- ºëµØ
- 0
- ¿n¤À
- 763
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOW7
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-16
- ³Ì«áµn¿ý
- 2017-3-14
|
¦^´_ 2# Hsieh
ª©¥D¥i¥H°Ý¤@Ó°ÝÃD¶Ü?
sumproduct¸Ì±ªº°Ï¶¡¥i¥H¥Î¤£¤@¼Ë?
§Ú¥H«e¥Î¥¦¨Ó§ì¸ê®Æ³£¬O¥Î¬Û¦P°Ï¶¡
ÁöµM¥ÎF9¬Ý¨ì¤½¦¡µ²ªG¦ý¬OÁÙ·Q¤£¥X
ISNUMBER($B$2:$B$80)*($B$3:$B$81="") ¸ò ISNUMBER($B$3:$B$80)*($B$2:$B$79="")
³o¨âÓ¨ìì²z |
|
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ
|
|
|
|
|
- ©«¤l
- 586
- ¥DÃD
- 123
- ºëµØ
- 0
- ¿n¤À
- 763
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOW7
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-16
- ³Ì«áµn¿ý
- 2017-3-14
|
¦^´_ 5# Hsieh
ÁÂÁª©¥D¦^À³
¸£µ¬ÁÙ¨S¿ìªk²z¸Ñ¦³ÂI¿ù¦ìªº°Ï¶¡µ²ªG
§Ú¦A·Q·Q |
|
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ
|
|
|
|
|