好åä½ æ¨å¤©å°±é®è¿ä¸ªé®é¢ï¼æ¯ä¸æ¯æ²¡æå¾å°æ»¡æççæ¡ææ ¹æ¬æ²¡äººåçä½ ï¼æ²¡æ¾å°é£ä¸ªé®é¢äºï¼ä¸å¾èç¥ã
å
¶å®æ¨å¤©å°±æç®åçä½ çæé®çï¼æªå¾è§èï¼è¿æ¯å¼å¾ç¹èµçãä½ä½ æé®æ²¡æä½ çè¦æ±è¯´æ¸
æ¥ï¼æ以没æåçä½ ãä»ä¹å«âéåºæ¥âï¼æ¯å°è¿äºæ°åç¨ç¹æ®çé¢è²æ 示è¿æ¯æå®ä»¬æåæ¥æ¾å°ä»ä¹ä½ç½®ï¼æ¤å¤æªå¾ä¸æ°å为B2-L2ï¼ä½æé®è¯´æä¸å´æ¯A2-K2ï¼å°åºæ¯ä»ä¹ï¼é®é¢ä¸æï¼æ以ä¸å¥½åçã
ç°å¨å°±å
说N2ä¸çå
¬å¼å§ï¼å°±æA2-K2ï¼
=IF(SUM(COUNTIF(A2:K3,{1,3,6,7,10})),"A","")
åæ¶æCtrl+Shift+Enterä¸é®è¾å
¥æ°ç»å
¬å¼
追é®è°¢è°¢åï¼å¯ä»¥å¦
追çå¦ä½âéåºæ¥âï¼è¿æ²¡æ说æå¢