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

­pºâÀx¦s®æ¼Æ¥Ø

­pºâÀx¦s®æ¼Æ¥Ø

¤j®a¦n,·Q½Ð°Ý¤@¤U­pºâÀx¦s®æ¼Æ¥Øªº¨ç¼Æ¬O¤°»ò?
§Ú·Q­pºâ¤@­Ó¤ë¤º­û¤u¿ð¨ì©M¥Ç¿ùªº¾÷²v,­Y·í¤é¦³¿ð¨ì©Î¥Ç¿ù«hµe¤e,§_«hªÅ¥Õ
²³æªº»¡´N¬O­nºâ½d³òÀx¦s®æ¤º´X­Ó¤e,¦A°£¥HÀx¦s®æ½d³ò¼Æ.
½Ð¦U¦ìÀ°§Ú¬Ý¤@¤Uªþ¥óªº c24 ©M d24­n«ç»ò³]©w¤ñ¸û¦n

Book2.rar (5.52 KB)

Jeffrey Chen

¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-4-13 09:33 ½s¿è

=COUNTIF(C3:C23,C3)/ROWS(3:23)

TOP

¦^´_ 1# jcman


    ¬O¤£¬O­n
X¼Æ¶q/Àx¦s®æ¼Æ¶q
C24°}¦C¤½¦¡
{=AVERAGE((C3:C23="O")*1)}
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ jcman ©ó 2011-4-12 11:06 ½s¿è

¾Ç²ß¤F,ÁÂÁ¤j®aªº«ü¾É

¥i§_½Ð±ÐHsieh ª©¥D,averageªº°}¦C¤½¦¡«Ü¦n¥Î,¦ý§Ú¹ê¦b¬Ý¤£¤ÓÀ´,¬O§_¥i¥H»¡©ú¤@¤U,©Î¦³¬ÛÃö¸ê®Æ¥i´M?¦A¦¸·PÁÂ
Jeffrey Chen

TOP

¦^´_ 4# jcman


    §AªºX¬O¥H¦r«¬Åã¥Ü¡A¨ä¹ê¥Lªº¦r¤¸¬OO
©Ò¥H¡Aºâ¦¡(¸ê®Æ½d³ò="O")*1
·|¶Ç¦^¤@­Ó°}¦C
¬OOªº¶Ç¦^TRUE*1=1
«DOªº¶Ç¦^FALSE*1=0
³o¨Ç1»P0©Ò§Î¦¨ªº°}¦C¨D¥­§¡­È´N¬Oµª®×
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¾Ç²ß¤F,ÁÂÁª©¤j
Jeffrey Chen

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD