- ©«¤l
- 7
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 18
- ÂI¦W
- 0
- §@·~¨t²Î
- Windonws
- ³nÅ骩¥»
- 7
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-6-10
- ³Ì«áµn¿ý
- 2013-6-15
|
½Ð°Ý§Ú¦³¤@±i¹Ïªí¡A¤w¸g©T©w¦n»Ýnø»sªºÀx¦s®æ¼Æ¡A©Ò¥Hì«h¤W¥un¦b¥u©wªº®æ¤l¤º¶ñ¤J¼Æ¦r¡A¹Ïªí´N·|¥ß§Y§ó·s(¥Ø«e¬O¨Ï¥Î§é½u¹Ï)
¦ý¬O²{¦b¸I¨ìªº°ÝÃD¬O¡Aè¦nn®³¨Ó»s¹ÏªºÀx¦s®æªºÈ¡A¨Ó·½¬O¥Ñ¤½¦¡¹Bºâ±o¨Ó¡A¨Ò¦pIF( A1="", "", A1)
¤]´N¬O»¡¡AÁöµMÀx¦s®æÅã¥Üªº¬OªÅ¥Õ¡A¦ý¬O¹ê»Ú¤W¬O¦³¤½¦¡ªº
¦]¦¹¦b¹Ïªí¤W¡A³o¨ÇªÅ¥ÕÀx¦s®æ·|³Q¦C¤J¹Ïªí¸Ì±¡A¦Ó¥B¼ÆȬ°¹s(½u·|³s¹L¥h)¡A
½Ð°Ý¬O§_¦³¿ìªk±Æ°£³o¨ÇªÅ¥Õ«o¤S±a¦³¤½¦¡ªºÀx¦s®æ¡AÅý³o¨Ç¹sÂI¤£n¥X²{¦b¹Ïªí¤º?
¬Û¦Pªºª¬ªp¤]¦bCOUNTA()³oÓ¨ç¼Æ¤¤¥X²{¡AÀx¦s®æÁöµM¬OªÅ¥Õ¡A¦ý¸ÌÀY¦³¤½¦¡ÁÙ¬O·|³Q®³¨Óºâ¶i¥h
¤£ª¾¹D¦³¨S¦³°ª¤â¯à°÷´À§Ú¸Ñµª¡A·P¿E¤£ºÉ~ |
|