[¤À¨É] Âø¶µ²Ó¥Ø¤Î¶O¥Î¦X­p

ML089

ªÀ°Ïªº¦¬¤äªí¤j³£©T©wªºÄæ¦ìªº¼Æ¦r¦X­p¡A¨ä¤¤¤@¶µÂø¶µª÷ÃB¨ä»¡©ú¦p¤U "«H«Ê$120+½¦¤ô$20+¥ÕªO$500+°j¯¾°w$120+¥ÕªOÀ¿$160"¡A
¦p¦ó±qÂø¶µ»¡©ú±N¨ä¤¤ªºª÷ÃB¦X­p?

A1 = "60­Ó«H«Ê$120+1²~½¦¤ô$20+1±i¥ÕªO$500+6²°°j¯¾°w$120+2­Ó¥ÕªOÀ¿$160"

¨C­Ó­n­pºâªºª÷ÃB«e­±­n¥[ $
B1 =SUMPRODUCT(--TEXT(LEFT(TEXT(MID(SUBSTITUTE(A1&"X","$",REPT(" ",16)),ROW($1:$999),16),),15),"[<>];;!0;!0"))

ML089

A1 = "88X + 86A + 844XE + 6XXA"
­n¦p¦ó±N 88 + 86 + 844 + 6 ­pºâ¥X 1024

B1 =SUMPRODUCT(--TEXT(LEFT(TEXT(MID(SUBSTITUTE("+"&A1&"X","+",REPT(" ",16)),ROW($1:$999),16),),15),"[<>];;!0;!0"))

ª`·N A1 = "88X + 86A + 844XE + 6XXA" ¤¤²Ä¤@­Ó¼Æ¦r«e­±¨S¦³ "+"¡A©Ò¥H¤½¦¡¤¤»Ý­n¸É¤W

ML089

¦^´_ 3# 074063


  ®æ¦¡¤£¦P¤½¦¡·íµM¤£¦P

=SUMPRODUCT(--TEXT(LEFT(TEXT(LEFT(A1:A4,COLUMN(B:Q)),),COLUMN(A:P)),"[<>];;!0;!0"))

ML089

¦^´_ 5# 074063

=SUMPRODUCT(--TEXT(LEFT(TEXT(LEFT(A1:D1,ROW($2:$16)),),ROW($1:$15)),"[<>];;!0;!0"))

ML089

¦^´_ 7# 074063


A1:D1
§ï¬°
IF(D10:F10<>"",D10:F10,$D$9:$F$9)


=SUM(--TEXT(LEFT(TEXT(LEFT(IF(D10:F10<>"",D10:F10,$D$9:$F$9),ROW($2:$16)),),ROW($1:$15)),"[<>];;!0;!0"))
»Ý¨Ï¥Î¤TÁä¿é¤J(CTRL+SHIFT+ENTER)

ML089

¦^´_ 9# 074063


     =SUM(--TEXT(LEFT(TEXT(LEFT(IF(D10:F10<>"",D10:F10,$D$9:$F$9)&"X",ROW($2:$16)),),ROW($1:$15)),"[<>];;!0;!0")) »Ý¨Ï¥Î¤TÁä¿é¤J(CTRL+SHIFT+ENTER)

ML089

¦^´_ 11# 074063


    ¼Ï¶s¤ÀªRªí§Ú¤£·|