æé®æ³è¦ç¨FREQUENCYå½æ°è®¡ç®æ¡ä»¶æ°æ®åé¢ä¸ªæ°ï¼é£å°±æ¥ä¸ªç¨FREQUENCYå½æ°çå ¬å¼ï¼å¦å¾ï¼éæ©
E2:E27
è¾å ¥å ¬å¼ï¼
=FREQUENCY(IF($A$2:$A$28=--LEFT(E$1),$B$2:$B$28),$D$2:$D$27)
åæ¶æCtrl+Shift+Enterä¸é®è¾å ¥æ°ç»å ¬å¼ï¼åå³æå°G2ï¼æå¤å°ä¸ªçå°±å³æå¤å°åï¼
éè¦æ³¨æçæ¯ï¼å ¬å¼ç»è®¡çç»æ对åºçæ°æ®åé¢è§Hå说æãå¦æè¾å ¥å ¬å¼åéæ©çèå´ä¸ºE2:E28ï¼é£ä¹æåä¸ä¸ªæ°æ®E28对åºçæ¯å¤§äº400ç个æ°ã