ªð¦^¦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

¦^´_ 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

¦^´_ 4# Hsieh

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

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 : ¨ü¤HÂI¤ô¤§®¦¡A¶··í´é¬u¥H³ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD