B1çå ¬å¼ä¸ºï¼
=SUM(A1)
æ ¢çï¼è¿ä¸ªA1çåä¸å°±æ¯A1åï¼æ¯ä¸æ¯é®A1åä½æ°åçåï¼ä¾å¦A1为12ï¼é£ä¹ç»æ为3ï¼å¦æè¿æ ·å ¬å¼ä¸ºï¼
=SUM(IFERROR(MID(A1,ROW($A$1:$A$10),1)+0,0))
æ°ç»å ¬å¼ï¼è¾å ¥å®æ¯æCTRL+SHIFT+ENTERï¼ååèªå¨åºç°{}ï¼å¦ä¸å¾ï¼
追é®2æ2å·å½æ¥è®¤è´A1fang为2. å½æ认è´B1æä¹è½å¨1å·çåºç¡ä¸èªå¨ç´¯å 2å·ç
追çä»ä½ çæåç解就æ¯SUM(A1)ï¼å½æ¥ãå½æä¸A1ãB1æä»ä¹å ³ç³»ä½ 没æ说å¦ï¼æ好ç»ä¸ªå¾ï¼å¹¶ä¸è¯¦ç»è¯´æ¸ æ¥ä½ å¿éæ³è¦çï¼å¦åå¯è½æ²¡åæ³å¸®ä½ ã