如下图中,各种喜欢的食物分别出现的次数是多少
åèå¾ç¤ºå ¬å¼ï¼
=SUMPRODUCT((LEN(B1:B5)>LEN(SUBSTITUTE(B1:B5,"çç±³","")))*1)
ä¸è¿è¦æ³¨æï¼è¿ä¸ªæ¹æ³æ¯æ缺é·çï¼æ¯å¦x人å欢 ç米饼ï¼ä¼è¢«ç»è®¡ä¸ºä¸ çç±³ ä¸æ ·ã