ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¦p¦ó²Î­p¥XDÄæ«DªÅ¦r¦êÀx¦s®æ¼Æ¥Ø

[µo°Ý] ¦p¦ó²Î­p¥XDÄæ«DªÅ¦r¦êÀx¦s®æ¼Æ¥Ø

½Ð±Ð¥ý¶i:

¦pªþ¥ó¤¤ªº±¡ªp, ¦p¦ó¤£¨Ì¾a¨ä¥LÄæ²Î­p¥X«DªÅ¦r¦êÀx¦s®æ¼Æ¥Ø.

Sonny.rar (7.49 KB)
ss

¦^´_ 1# sunnyso

=countblank(Z:Z)-countblank(D:D) ?

TOP

¦^´_ 2# Bodhidharma

ÁÂÁ¤j¤j.
³æ¾aDÄæ¦n¹³¨S¿ìªk¬O¶Ü?
¦]爲:
1. 2003 ©M 2010 ªºÁ`ROW¼Æ¤£¤@¼Ë
2. countif ¦n¹³ª½±µµLªk§PÂ_¥X¥Î¨ç¼Æªþ­Èªº"" (¨Ò¦p: iferror(true, ""))
ss

TOP

¦^´_ 3# sunnyso

§A¨ì©³­nºâ¬Æ»ò¼Æ¶q?
¬ODÄ檺«DªÅ®æ¼Æ¶q¶Ü?
=ROWS(D:D)-COUNTBLANK(D:D)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh

³o¥¿¬O§Ú­nªºµª®×¡C·PÁ¶Wª©¡C¤@®É·Q¤£°_¦³¤°麽¨ç¼Æ¥i¥HreturnÁ`¦C¼Æ, ­ì¨Ó´N¬Orows¡]¡^
ss

TOP

¦^´_ 4# Hsieh

À³¸Ó¬O¦b¬ã¨s¡u""¡v¦bexcel¤¤¬O¦p¦ó³Q­pºâªº§a
­è­è¸Õ¤F¤@¤U
counta(D:D)¡G©Ò¦³«DªÅ¥ÕÀx¦s®æ(¥]§t"")
countif(D:D,"*")¡G©Ò¦³¤å¦r(¥]§t"")
count(D:D)¡G©Ò¦³¼Æ¦r
countif(D:D,"*?")¡G©Ò¦³¤å¦r(¤£¥]§t"")

©Ò¥H¥i¥H¥Îcount(D:D)+countif(D:D,"*?")

TOP

¦^´_ 6# Bodhidharma

¥¿¦b¬ã¨s "", countif, isblank, =¡§¡¨, ¹ï¨ç¼Æreturnªº=""¦p¦ó³B²z

ÁÙ¦³µo²{ countif(   , "><") ¥i¥H§PÂ_¥X¤å¦r¤£§t¼ÐÂI²Å¸¹
¤£ª¾¹Dexcel¤¤­þ¸Ì¦³countifªº±ø¥ó³]©w¸Ô²Ó»¡©ú
ss

TOP

        ÀR«ä¦Û¦b : µÊ®ð¼L¤Ú¤£¦n¡A¤ß¦a¦A¦n¤]¤£¯àºâ¬O¦n¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD