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

[µo°Ý] SUMPRODUCT ??

[µo°Ý] SUMPRODUCT ??

¨D²Å¦X KÄæ> 1 (K21:K350),¦P®É hÄæ< -1 (h21:h350) ªº­Ó¼Æ ,¤½¦¡¬°?? Book3.zip (68.57 KB)
µª®×¬° 1
¥u¦³ 84¦C²Å¦X k84=1.81   h84= -1.31

¦^´_ 1# t8899

    ¸Õ¸Õ
    =SUMPRODUCT((K21:K350>1)*(H21:H350<-1))

TOP

¦^´_  t8899

    ¸Õ¸Õ
    =SUMPRODUCT((K21:K350>1)*(H21:H350
owen06 µoªí©ó 2014-12-23 12:06

©_©Ç¡A§Ú§â¥¦§ï¦¨  =SUMPRODUCT((K21:K350>1)*(H21:H350>1))
µª®×Åܦ¨ 251 ???¿ùªºµª®×

TOP

¥»©«³Ì«á¥Ñ freeffly ©ó 2014-12-23 14:51 ½s¿è

¦^´_ 3# t8899


    ¦pªG°Ï¶¡¥u³]¨ì99µª®×¬O0
    350-99=251
    §Ú²qÀ³¸Ó¬O¤½¦¡§PÂ_¨S¦³­Èªº¨º³¡¥÷¬O¤j©ó1

     ³o³¡¥÷ªº­ì²z¦³«Ý¨ä¥Lª¾ÃѤñ¸û²`ªº°ª¤â¦^µª
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¥»©«³Ì«á¥Ñ tku0216 ©ó 2014-12-23 15:22 ½s¿è

¦^´_ 1# t8899

©_©Ç¡A§Ú¥Î¿z¿ï¬Ý¤F¤@¤U¡AÀ³¸Ó¬O¦³15µ§¸ê®Æ²Å¦X§Aªº°ÝÃD¡A¨£¤U¹Ï¡G

§Ú¬O¥Î¤½¦¡=COUNTIFS(K21:K99,">1",H21:H99,"<1")¡A¥i¥H±o¨ì15³oµª®×¡C

¥t¥~¡A±N½d³ò¼W¥[¨ìK21:K350»PH21:H350¡A¤@¼Ë·|±o¨ì15³o­Óµª®×¡C

TOP

¤w¸Ñ¨M  ¥[ (K21:K350<>"")
¤½¦¡§PÂ_¨S¦³­È¡]ºë½Tªº»¡¬OªÅ­È¡^ªº¨º³¡¥÷¬O¤j©ó1,""Áö¬OªÅ¥Õ¦ý¤´¬O­Ó¤å¦r¡A¤å¦r¤j©ó¼Æ¦r

TOP

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