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

[µo°Ý] ±ø¥ó­p¼Æ¤p°ÝÃD

[µo°Ý] ±ø¥ó­p¼Æ¤p°ÝÃD

Dear¤j¤j­Ì¡G
    ¦b¿z¿ï±ø¥ó¶i¦æ­p¼Æ¡A¦ý¬O·Q°w¹ï¦³¼Æ¾Úªº³¡¤À¡A¶i¦æ­p¼Æ¡C¤£ª¾¦p¦ó±Æ°£ªÅ­È¡C
     ¦pªþ¾×¡A·PÁÂ


    ±ø¥ó­p¼Æ.zip (9.02 KB)

¦^´_ 1# jj369963


    =COUNTIFS(E2:E15,">=3",$B$2:$B$15,$M$3,$A$2:$A$15,$N$3,$C$2:$C$15,$O$3)/COUNTIFS(E2:E15,"<>",$B$2:$B$15,$M$3,$A$2:$A$15,$N$3,$C$2:$C$15,$O$3)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089

Dear ML089¤j¤j¡G
¦pªG§Úªº°Ñ·Ó¦ì¸m¡A¦³¥Î¤½¦¡""¼gªºªÅ­È¡A°õ¦æ¤½¦¡®É¡A·|§â¥¦µø¬°¦³­È¨Ó­p¼Æ¡A³y¦¨¼Æ¾Ú¿ù»~¡C¸Ó¦p¦ó­×¥¿¡C

¦pªþÀÉ·PÁÂ

±ø¥ó­p¼Æ2.zip (9.75 KB)

TOP

¦^´_ 3# jj369963


M15=SUMPRODUCT(($A$2:$A$15=$N$13)*($B$2:$B$15=$M$13)*(E$2:E$15<>"")*(E$2:E$15>=3))/SUMPRODUCT(($A$2:$A$15=$N$13)*($B$2:$B$15=$M$13)*(E$2:E$15<>""))
M16=SUMPRODUCT(($A$2:$A$15=$N$13)*($B$2:$B$15=$M$13)*(E$2:E$15<>"")*(E$2:E$15<3))/SUMPRODUCT(($A$2:$A$15=$N$13)*($B$2:$B$15=$M$13)*(E$2:E$15<>""))
¦V¥k½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2014-9-16 09:59 ½s¿è

¦^´_ 3# jj369963

¿z¿ï±ø¥ó M3:O3 ­YµL¸ê®Æ®É»Ý¶ñ *

M5
=IFERROR(COUNTIFS(E2:E15,">=3",$B$2:$B$15,$M$3,$A$2:$A$15,$N$3,$C$2:$C$15,$O$3)/COUNTIFS(E2:E15,">0",$B$2:$B$15,$M$3,$A$2:$A$15,$N$3,$C$2:$C$15,$O$3),"")
¥k©Ô

M6
=IF(M5="","",1-M5)
¥k©Ô


±ø¥ó­p¼Æ2_ML089.rar (10.66 KB)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# ML089


    Dear ML089ª©¤j¡G

  ¦A³Â·Ð«ü±Ð¡A¥Î¤F¦U¦¡¦U¼Ëªº¤è¦¡¡A´N¬O§Ë¤£¥X¨Ó¡C
¦pªþÀÉ

·PÁÂ

¤p°ÝÃD½Ð±Ð.zip (13.19 KB)

TOP

¦^´_ 6# jj369963


    ¤p°ÝÃD½Ð±Ð.rar (15.17 KB)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¯à·F¤£·F¡A¤£¦p­W·F¹ê·F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD