经常需要用到Excel的小伙伴肯定对COUNT计数函数不陌生,默默以前也讲过COUNT函数,只是随其他的函数功能一起讲的,今天就系统性的讲一下Exc
ç»å¸¸éè¦ç¨å°Excelçå°ä¼ä¼´è¯å®å¯¹COUNT计æ°å½æ°ä¸éçï¼é»é»ä»¥åä¹è®²è¿COUNTå½æ°ï¼åªæ¯éå ¶ä»çå½æ°åè½ä¸èµ·è®²çï¼ä»å¤©å°±ç³»ç»æ§ç讲ä¸ä¸Excelä¸ç计æ°å½æ°å®¶æï¼å æ¬ï¼COUNTï¼COUNTAï¼COUNTBLANKï¼COUNTIFï¼COUNTIFSï¼åå«å¯¹è¿å ç§å½æ°ç解éåæä½å®ä¾è¿è¡æ¼ç¤ºã
COUNTå½æ°
å ¬å¼ï¼=COUNT(B1:B9)ï¼å ¶ç®çæ¯è®¡ç®B1-B9åå æ ¼ä¸æ°åç个æ°
éä¹ï¼å¨C2åå æ ¼ä¸è¾å ¥"=COUNT(B1:B9)"å ¬å¼ï¼å¯ä»¥çå°B1-B9åå æ ¼ä¸ï¼ä¸ä¸ªåå æ ¼ä¸æ¯ä¸æï¼è®¡æ°ï¼ï¼ä¸ä¸ªåå æ ¼ä¸æ¯ç©ºæ ¼ï¼åªæäºä¸ªåå æ ¼ææ°åï¼å ¬å¼çè¿åç»æå°±æ¯"5",COUNTå½æ°åªè®¡ç®äºææ°åçåå æ ¼ï¼èæç©ºæ ¼ãä¸æåå æ ¼æé¤å¨å¤ã
COUNTAå½æ°
å ¬å¼ï¼=COUNTA(B1:B9)ï¼å ¶ç®çæ¯è®¡ç®B1-B9åå æ ¼ä¸éç©ºæ ¼ç个æ°
éä¹ï¼å¨C2åå æ ¼ä¸è¾å ¥"=COUNTA(B1:B9)"å ¬å¼ï¼å¯ä»¥çå°B1-B9åå æ ¼ä¸ï¼ä¸ä¸ªåå æ ¼ä¸æ¯ä¸æï¼è®¡æ°ï¼ï¼ä¸ä¸ªåå æ ¼ä¸æ¯ç©ºæ ¼ï¼äºä¸ªåå æ ¼ææ°åï¼å ¬å¼çè¿åç»æå°±æ¯"6",COUNTå½æ°åªæé¤äºç©ºæ ¼çåå æ ¼ï¼èææ°åãä¸æåå æ ¼ç»è®¡å¨å ã
COUNTBLANK
å ¬å¼ï¼=COUNTBLANK(B1:B9)ï¼å ¶ç®çæ¯è®¡ç®B1-B9åå æ ¼ä¸ç©ºæ ¼ç个æ°
éä¹ï¼å¨C2åå æ ¼ä¸è¾å ¥"=COUNTBLANK(B1:B9)"å ¬å¼ï¼å¯ä»¥çå°B1-B9åå æ ¼ä¸ä¸å ±æ9个åå æ ¼ï¼å ¶ä¸ä¸ä¸ªåå æ ¼ä¸æ¯ä¸æï¼è®¡æ°ï¼ï¼ä¸ä¸ªåå æ ¼ä¸æ¯ç©ºæ ¼ï¼äºä¸ªåå æ ¼ææ°åï¼å ¬å¼çè¿åç»æå°±æ¯"3",æ以COUNTBLANKå½æ°åªç»è®¡ç©ºæ ¼çåå æ ¼ï¼èæææ°ååæä¸æçåå æ ¼ç»è®¡æé¤äºã
COUNTIF
å ¬å¼ï¼=COUNTIF(B1:B9,"女")ï¼å ¶ç®çæ¯è®¡ç®B1-B9åå æ ¼ä¸æ§å«ä¸º'女'ç人æ°
éä¹ï¼å¨D2åå æ ¼ä¸è¾å ¥"=COUNTIF(B1:B9,"女")"å ¬å¼ï¼ç»è®¡B1:B9ä¸ä¸º“女”ç个æ°ï¼è¿åç»æ为3,å¦æéè¦ç»è®¡ä¸ä¸º"女"ç个æ°ï¼åæ¯ï¼"=COUNTIF(B1:B14,"<>女")"å ¬å¼ï¼è¿éæ·»å è¿ç®ç¬¦“<>”ï¼è¿åç»æ为5ï¼è¿ééè¦æ³¨æçæ¯ï¼å½ä½ ç»è®¡æ§å«ä¸ä¸º"女"çæ¶å,å ¶Båçæ é¢ä¹ä¼è¢«ç»è®¡è¿å»ãåçï¼å¯¹ææ°ååè¿è¡ç»è®¡è®¡æ°ï¼ä¹å¯ä»¥æ·»å 大äºå°äºçæ°åèå´ï¼å°ä¼ä¼´ä»¬å¯èªè¡å°è¯ã
COUNTIFS
å ¬å¼ï¼=COUNTIFS(C1:C9,"ä¸å¹´çº§",B1:B9,"ç·")ï¼èµ·å°ç»è®¡ä¸å¹´çº§ç·ççæ°é
éä¹ï¼å¨D2åå æ ¼ä¸è¾å ¥"=COUNTIFS(C1:C9,"ä¸å¹´çº§",B1:B9,"ç·")"å ¬å¼ï¼åæéæ±åç°ï¼æ们ä¸å ±ä¸¤ä¸ªéæ±ï¼ç¬¬ä¸ä¸ªæ¡ä»¶æ¯ï¼ä¸å¹´çº§ï¼ç¬¬äºä¸ªæ¡ä»¶æ¯ï¼ç·çï¼æ以å ç¨å ¬å¼"C1:C9,"ä¸å¹´çº§""ç»è®¡C1å°C9çä¸å¹´çº§äººæ°ï¼åè¾å ¥"B1:B9,"ç·""ç»è®¡B1å°B9çç·ç人æ°ï¼ä¸é´ç¨éå·éå¼ï¼æç»ç»ä¸ç±"COUNTIFS"å½æ°ç»è®¡ã
以ä¸å°±æ¯è®¡æ°å½æ°COUNT家æä¸ææçæåï¼å°ä¼ä¼´ä»¬åºè¯¥é½å¦ä¼äºå§~å欢çå°ä¼ä¼´è®°å¾ç¹èµæ¶èå¦ï¼ä½ 们çæ¯æå°±æ¯é»é»æ大çå¨åï¼è°¢è°¢ã