ãã许å¤äººå¨è¿ç¨excelçæ¶åï¼é½åªè½ç®åçæ±åï¼æ±å¹³åå¼ï¼æåºçï¼å
¶å®é£äºé½æ¯ç®æ¯ï¼excelä¸æ许å¤é«çº§çåºç¨ï¼å¦ä¼åä¼è®©ä½ å¿«é对æ°æ®è¿è¡åæï¼ç»è®¡ãä»å¤©ä»ç»çå°±æ¯å¦ä½ç»è®¡åæ°æ®µäººæ°ãå¦ä¸å¾æ示ï¼æ们è¦çæ以ä¸çç»è®¡ç»æï¼æ¥æ¯è¾1ç2çå个åæ°æ®µç人æ°ã
ããæ¹æ³/æ¥éª¤
ããé¦å
æ们è¦æåå§åæ°ï¼æ们è¿å¿å设1ç82人ï¼æ°æ®åæ¾å¨æ°æ®è¡¨â1âä¸ï¼æ»åå¨Zåï¼2ç81人ï¼æ°æ®åæ¾å¨æ°æ®è¡¨â2âä¸ï¼æ»åä¹å¨Zåãæ们è¦å°ç»è®¡ç»ææ¾ç¤ºå¨å¦ä¸ä¸ªæ°æ®è¡¨â1ã2çæ»ååæ°æ®µâéã
ããç¹å»â1ã2çæ»ååæ°æ®µâæ°æ®è¡¨ï¼é¦å
å°æ³ç»è®¡çåæ°æ®µæ³å¥½ï¼å¨æ¤æ°æ®è¡¨ä¸å¦ä¸å¾æ示ï¼å好å¸å±ã
ããä¸é¢å°±è¦è¾å
¥å
¬å¼äºï¼å¦ä¸å¾æ示ï¼å¨b37åå
æ ¼éè¾å
¥å
¬å¼â=COUNTIF('1'!Z2:Z83,">=600")â,ç¡®å®ä¹åï¼B37åå
æ ¼éå°±ä¼æ¾ç¤ºç»è®¡åºç1ç600å以ä¸ç人æ°ã
ãã以æ¤ç±»æ¨ï¼å¨38åå
æ ¼éè¾å
¥ï¼æè
å¤å¶ç²è´´åè¿è¡ä¿®æ¹ï¼å
¬å¼â=COUNTIF('1'!Z2:Z83,">=590")âå³å¯ç»è®¡åº1ç590å以ä¸ç人æ°ã
ãã5
ããé£ä¹å¦ä½ç»è®¡2çå个åæ°æ®µç人æ°å¢ï¼åªéè¦å°1çå·²ç»ä¿®æ¹å¥½çå
¬å¼â=COUNTIF('1'!Z2:Z83,">=590")âä¸ç1'æ¿æ¢æ2'ï¼å³å¯ãå¦æä½ å¨å¤å¶ç²è´´çæ¶åï¼åç°Z2ï¼Z83åæäºAA2ï¼AA83ï¼é£è¿æä¸ä¸ªåæ³è®©ä»ä¸ä¼åçååãå°Z2ï¼Z83å®å
¨æ¿æ¢æ$Z$2:$Z$83å°±å¯ä»¥äºãè¿æç»è®¡2çåæ°æ®µçæ¶åï¼è®°å¾å°83æ¹ä¸º82åï¼å 为2çåªæ81个人åã
温馨提示:答案为网友推荐,仅供参考