å ¬å¼å¯ä»¥æå¤ä¸ªï¼ä½ä¸é¢è¿ä¸ªåºè¯¥æ¯é»è¾æ¯è¾æç¡®çï¼å å¤ææ¯å¦æå ³é®é¡¹ä¸éè¿ï¼å®è¡ä¸ç¥¨å¦å³ãå ³é®é¡¹å ¨é¨éè¿æ¶ï¼åå¤ææ¯å¦8æ¡ä»¥ä¸éè¿ã
ä½æé®ä¸è¯´âç»æè¦è¿åå°D4âï¼èD4ä¸å·²æå 容ï¼æ以åºè¯¥ä¸ä¼æ¯D4å§ï¼èªå·±å»éä½ç½®å§ï¼åæ£å ¬å¼ä¸æ ·ï¼
=IF(COUNTIFS(C5:C15,"â ",E5:E15,"ä¸éè¿"),"ä¸éè¿",IF(COUNTIF(E5:E15,"éè¿")>=8,"éè¿","ä¸éè¿"))