[µo°Ý] ³æ®æ¦³¤å¦r¤¤ªº¼Æ¦r¥[Á` ¤ì§÷

kkooo15

³æ®æ¦³¤å¦r¤¤ªº¼Æ¦r¥[Á`.¤£ª¾¬O§_¦³§ó¦nªº¤èªk©Î¤è¦¡¡A¥i¥H¤£¥Î¤@­Ó¤@­Ó¦Û¦æ¿é¤J?

Å]´¹¥Û(20736) ¤ì§÷(41472) ª÷ÄÝ(548090) ¨F¥Û(167173) ­¹ª«(550027)
Å]´¹¥Û(352512) ¤ì§÷(113132) ª÷ÄÝ(137606) ­¹ª«(275213) ¨F¥Û(912384)
Å]´¹¥Û(203968) ¤ì§÷(41472) ª÷ÄÝ(41472) ¨F¥Û(82944) ­¹ª«(82944)
Å]´¹¥Û(20736) ¤ì§÷(783768) ª÷ÄÝ(41472) ¨F¥Û(283554) ­¹ª«(995328)
Å]´¹¥Û(258985) ¤ì§÷(344060) ª÷ÄÝ(41472) ­¹ª«(82944) ¨F¥Û(82944)
Å]´¹¥Û(20736) ¤ì§÷(41472) ª÷ÄÝ(205176) ­¹ª«(82944) ¨F¥Û(1553474)
Å]´¹¥Û(270977) ¤ì§÷(41472) ª÷ÄÝ(41472) ­¹ª«(609969) ¨F¥Û(204292)

¥[Á`¼Æ­È
="Å]´¹¥Û("&SUMPRODUCT(--MID(A1:A7,FIND("(",A1:A7,FIND("Å]´¹¥Û",A1:A7))+1,FIND(")",A1:A7,FIND("Å]´¹¥Û",A1:A7))-FIND("(",A1:A7,FIND("Å]´¹¥Û",A1:A7))-1))&")"

="¤ì§÷("&SUMPRODUCT(--MID(A1:A7,FIND("(",A1:A7,FIND("¤ì§÷",A1:A7))+1,FIND(")",A1:A7,FIND("¤ì§÷",A1:A7))-FIND("(",A1:A7,FIND("¤ì§÷",A1:A7))-1))&")"

="ª÷ÄÝ("&SUMPRODUCT(--MID(A1:A7,FIND("(",A1:A7,FIND("ª÷ÄÝ",A1:A7))+1,FIND(")",A1:A7,FIND("ª÷ÄÝ",A1:A7))-FIND("(",A1:A7,FIND("ª÷ÄÝ",A1:A7))-1))&")"

="¨F¥Û("&SUMPRODUCT(--MID(A1:A7,FIND("(",A1:A7,FIND("¨F¥Û",A1:A7))+1,FIND(")",A1:A7,FIND("¨F¥Û",A1:A7))-FIND("(",A1:A7,FIND("¨F¥Û",A1:A7))-1))&")"

="­¹ª«("&SUMPRODUCT(--MID(A1:A7,FIND("(",A1:A7,FIND("­¹ª«",A1:A7))+1,FIND(")",A1:A7,FIND("­¹ª«",A1:A7))-FIND("(",A1:A7,FIND("­¹ª«",A1:A7))-1))&")"

Hsieh

¦^´_ 3# kkooo15
¸ê®Æ­åªR«á¨Ï¥ÎSUMIF¨ç¼Æ


   

¤U¸ü (743.44 KB)

2012-2-2 17:58

kkooo15

¦^´_ 2# Hsieh

·PÁÂ Hsieh
²Ä¤@­Ó¤èªk
=SUMPRODUCT(--MID($A$1:$A$7,FIND($B1,$A$1:$A$7)+LEN($B1)+1,FIND(")",$A$1:$A$7,FIND($B1,$A$1:$A$7)+LEN($B1)+1)-(FIND($B1,$A$1:$A$7)+LEN($B1)+1))*1)
¥Î³o­Ó¤è¦¡¥i¥H¤U©Ô..¦ý¦pªGa8­n¼W¥[¸ê·½´N¥þ­n­«¼g¤F¡C

²Ä¤G­Ó¤èªk
¤@¼Ë¤@¼Ë¥ý§ä¥X¨ÓµM«á¦b¥[Á`
ÀHµM»Ý­n¥Î¨ìªº¦ì¸m¤ñ¸û¦h¦ý¦pªG¸ê­n»Ý­n¼W¥[¤]¤£©È
ÁÙ¬O³Ì¦n¥Îªº

·PÁ Hsieh ¤À¨É

Hsieh

¦^´_ 1# kkooo15


   

¤U¸ü (67.9 KB)

2012-2-2 14:49