=SUM(IF(ISNUMBER(--SUBSTITUTE(A1:A10,"ab","")),--SUBSTITUTE(A1:A10,"ab",""),0))
ä¸é¢çå
¬å¼ï¼å设æ°æ®å¨A1:A10,å设æ°æ®å¼å¤´çåæ¯æ¯ab
ç¨ä¸é¢çå
¬å¼ï¼è¾å
¥åæctrl+shift+å车ï¼è¦ä¸é®ä¸èµ·æï¼ä¸é¢çå
¬å¼å¯ä»¥ç´æ¥è®¡ç®åºå¼å¤´ä¸ºabçæ°åçæ»å
æ¿æ¢abåæ¹åèå´ï¼åºè¯¥å¯ä»¥å®ç°ä½ çè¦æ±ã
å¦æä½ çç©åå¾å¤ï¼å¯æåååå¨Dåï¼ç¶åå
¬å¼æ¹ä¸ºï¼=SUM(IF(ISNUMBER(--SUBSTITUTE($A$1:$A$10,D1,"")),--SUBSTITUTE($A$1:$A$10,D1,""),0))
ä¸æå°±å¯ä»¥æ±åºææçåç§ çåèªå计æ°
温馨提示:答案为网友推荐,仅供参考