ããå·¥å
·/åæ
ããmicrosoft office excel 2007
ããæ¹æ³/æ¥éª¤
ããæå¼éç¼è¾çExcelææ¡£ï¼å¦ä¸ãå·²ç¥ä¸ç»ååï¼æç·æ女ï¼éè¦æç
§âç·âãâ女âè¿ä¸¤ä¸ªå段åå«ç»è®¡ä¸ªæ°ã并计ç®ä¸¤ä¸ªå段çå¹³åå¼ã
ããä¸ï¼è®¡ç®å¥³ç个æ°
ããå°å
æ 移å¨å°D2åå
æ ¼ä¸ï¼è¾å
¥å½æ°å
¬å¸=COUNTIF(C2:C21,"女")ï¼ãæEnteré®å³å¾åºç»æã
ããäºï¼è®¡ç®ç·ç个æ°
ããåçï¼å°å
æ 移å¨å°D6åå
æ ¼ä¸ï¼è¾å
¥å½æ°=COUNTIF(C2:C21,"ç·")ï¼ãæEnteré®å³å¾åºç»æã
ããä¸ï¼è®¡ç®ç·çå¹³åå¹´é¾
ããè¿éæå大家ä»ç»3ç§è¾ä¸ºå¸¸ç¨å容æè®°å¿çå½æ°ï¼è®¡ç®ä¸¤ä¸ªå段çå¹³åå¹´é¾ãæå
´è¶£çæåä¸å¦¨ä¸é
ï¼
ãã1.å°å
æ 移å¨å°D10åå
æ ¼ä¸ï¼è¾å
¥ä¸é¢çå½æ°=SUMIF(C2:C21,"ç·",B2:B21)/COUNTIF(C2:C21,"ç·")ï¼ãæEnteré®å³å¾åºç»æï¼
ãã说æï¼éè¿æ¥éª¤3ï¼å¾ç¥countifå½æ°æ¯ç¨æ¥ç»è®¡ç·çç个æ°ï¼é£ä¹ï¼å½æ°çåå段sumifå½æ°çææå°±å¾æäºäºï¼æ¯ä¸ºäºè®¡ç®Båä¸ææç·ççå¹´é¾æ»åï¼
ãã2.ä¸é¢ä»ç»ä¸ç§æ°çå½æ°ï¼ä¸ºäºå¯¹æ¯ï¼å°D10åå
æ ¼çå½æ°æ°å¼ä¿çãå°å
æ 移å¨å°D11åå
æ ¼ï¼éæ°è¾å
¥ä¸ä¸ªæ°çå½æ°=AVERAGEIF(C2:C21,"ç·",B2:B21) æä¸Enteré® æ¥çå¾å°çç»æ æ¯ä¸æ¯åæ¹æ³1çç»æä¸æ¨¡ä¸æ ·å¢ï¼
ãã3.继ç»ä»ç»ç¬¬ä¸ç§æ°çå½æ°ï¼ä¸ºäºå¯¹æ¯ï¼å°D10åD11åå
æ ¼çå½æ°å¼é½ä¿çãå°å
æ 移å¨å°D12åå
æ ¼ä¸ï¼ç»§ç»è¾å
¥ä¸ä¸ªæ°çå½æ°=AVERAGE(IF(C2:C21="ç·",B2:B21)) æ¤æ¶æä¸Ctrl+Shift+Enterå¿«æ·é®ï¼ä¸è¦æéï¼è¿éï¼æ³¨æä¸è½ç´æ¥æEnteré®ï¼ æ¥çå¾å°çç»æ ååé¢ä¸¤ç§å½æ°å¾å°çç»ææ¯ä¸è´çï¼
ããåï¼è®¡ç®å¥³çå¹³åå¹´é¾
ãã女çå¹³åå¹´é¾ç计ç®æ¹æ³åç·çå¹³åå¹´é¾ç计ç®æ³ã为äºå¤§å®¶æ¹ä¾¿ï¼è¿éæå°ä¸ç§è®¡ç®å¥³çå¹³åå¹´é¾çå½æ°å
¬å¼å¼ è´´åºæ¥ï¼å¦ä¸æ示ï¼
ãã=SUMIF(C2:C21,"女",B2:B21)/COUNTIF(C2:C21,"女")
ãã=AVERAGEIF(C2:C21,"女",B2:B21)
ãã=AVERAGE(IF(C2:C21="女",B2:B21))
ããå
·ä½çæä½ç»æãç¹å«æéï¼ç¬¬ä¸ä¸ªå½æ°è¾å
¥åï¼æCtrl+Shift+Enteré®å¾åºç»æææ¯æ£ç¡®çï¼
ããäºï¼è®¡ç®20å°30å²å¹´é¾æ®µç女ç人æ°
ããè¿ééè¦ç¨å°ä¸ä¸ªæ°çå½æ°=countifs(æ¡ä»¶åºå1,æ¡ä»¶1,æ¡ä»¶åºå2,æ¡ä»¶2â¦â¦)ï¼æ¤å½æ°åºç¨äºå¤æ¡ä»¶ç»è®¡ä¸ã
ããå¦å¾ï¼å°å
æ 移å¨å°D18åå
æ ¼ä¸ï¼è¾å
¥å½æ°=COUNTIFS(C2:C21,"女",B2:B21,">20",B2:B21,"<30") æEnteré®æ¥çç»æ为2 å
·ä½æ¥éª¤è§ä¸å¾ï¼
ããå
ï¼è®¡ç®30å°40å²å¹´é¾æ®µçç·ç人æ°
ããæ¹æ³æ¥éª¤åè§æ¥éª¤8.å°å
æ 移å¨å°D22åå
æ ¼ä¹ä¸ï¼è¾å
¥å½æ°=COUNTIFS(C2:C21,"ç·",B2:B21,">30",B2:B21,"<40") ãæ¤å½æ°åä¸è¿°ç»è®¡å¥³çå¹´é¾æ®µäººæ°çä¸åä¹å¤ å³æ¡ä»¶1çå¼æ¹ä¸ºäº"ç·" ï¼æ¡ä»¶2çå¼æ¹ä¸º">30"ï¼æ¡ä»¶3çå¼æ¹ä¸º"<40"ï¼å
¶ä»ååãæEnteré® æ¥çç»æ å¦å¾ç¤ºã
温馨提示:答案为网友推荐,仅供参考