[µo°Ý] SUMPRODUCT¨ç¼Æ+OR°Ý´£½Ð±Ð

KITTYBOY

DEAR  ALL¤j¤j -
1.¤p§Ì¼g¤@µ{¦¡¦p¤U.°õ¦æµL°ÝÃD
=SUMPRODUCT(ISNUMBER(SEARCH("CC",$F$1:$F$60000))*ISNUMBER(SEARCH("¤é¥ß",$G$1:$G$60000))*ISNUMBER(SEARCH("C2",$E$1:$E$60000)),$R$1:$R$60000)
2.¦ý­ì±ø¥ó ISNUMBER(SEARCH("¤é¥ß",$G$1:$G$60000)) ·Q¥[¤J¤@ OR  ±ø¥ó¬°¦p¤U  
   2.1 §Y  G1:G60000  °£§t¦³­ì±ø¥ó  ¤é¥ß ¦r¤¸¦¨¥ß¥~.  ·Q·s¼W±ø¥ó  = §t¦³¤é¥ß ©Î MCL  ¦r¤¸§¡¦¨¥ß.
   2.2 §ï¦p¤U  OR(ISNUMBER(SEARCH("¤é¥ß",$G$1:$G$60000)),ISNUMBER(SEARCH("MCL",$G$1:$G$60000)))
        µLªk§ì¨ú¥X²Î­p¸ê®Æ
'=SUMPRODUCT(ISNUMBER(SEARCH("CC",$F$1:$F$60000))*OR(ISNUMBER(SEARCH("¤é¥ß",$G$1:$G$60000)),ISNUMBER(SEARCH("MCL",$G$1:$G$60000)))*ISNUMBER(SEARCH("C2",$E$1:$E$60000)),$R$1:$R$60000)
3.µ{¦¡¦p¦ó­×§ï.·Ð¤£§[½ç±Ð   THANKS*10000

KITTYBOY

¦^´_ 2# zz5151353

DERA ¤j¤j
  ±z´£¨Ñ¤§¨ç¼Æ¥X²{BUG¦p¤U¹Ï¦pªþÀÉ  ·Ð±z¦A¤£§[«ü¾É. THANKS

KITTYBOY

DEAR  zz5151353 ¤j¤j-
²Å¦X¶·¨D.THANKS *10000

DEAR  victorl  ¤j¤j-
SUMIF µLªk²Å¦ó§Ú¦h±ø¥ó¤§»Ý¨D.THANKS.

KITTYBOY

¦^´_ 6# KITTYBOY

DEAR  ALL¤j¤j -
1.±N±z«ü¾É¤§µ{¦¡¨Ï¥Î©ó¦pªþÀÉ®×.¨q¥X 0 ????  
    1.1 ­ì¤é¥ß¥[Á`     =RANGE("B1")    10119
          ¦ý¤é¥ß  ©Î MCL ¤§¥[Á` =RANGE("B2")    0
          À³ >= 10119 ¤~¹ï.
2.·Ð¦A¤£§[½ç±Ð.  THANKS

KITTYBOY

¦^´_ 10# zz5151353


    DEAR  HSIEH   PD961A  ZZ5151353  ALL  ¤j¤j -
       ·PÁ±z­Ì¤§«ü¾É.µ{¦¡TEST«á¹B§@¥¿±`   THANKS*10000