å¯ä»¥æ两ç§åæ³ã
æ³ä¸ï¼å°æ°å转æ¢ä¸ºææ¬æ ¼å¼ãæ¹æ³æ¯ï¼éä¸æ°æ®åï¼åå»èåâæ°æ®âââãâååâï¼ä¸ä¸æ¥ï¼ä¸ä¸æ¥ï¼éâææ¬âæ ¼å¼ï¼å®æã
ç¶ååç¨ä¸é¢çå
¬å¼ï¼
=countif(a1:a5,"*1*")
=countif(a1:a5,"*23*")
ä¸å¼å设äºä»½è¯å·ççæ¡å¨A1:A5ä¸ã
æ³äºï¼
ç´æ¥ç¨ä¸é¢çå
¬å¼ç»è®¡ï¼
=SUMPRODUCT(ISNUMBER(FIND(1,A1:A5))*1)
=SUMPRODUCT(ISNUMBER(FIND(23,A1:A5))*1)
温馨提示:答案为网友推荐,仅供参考