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

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

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

³æ®æ¦³¤å¦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))&")"
excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA

¦^´_ 1# kkooo15


   
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 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 ¤À¨É
excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA

TOP

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


    play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¦n¨Æ­n´£±o°_¡A¬O«D­n©ñ±o¤U¡A¦¨´N§O¤H§Y¬O¦¨´N¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD