æ¡ä»¶è®¡æ°å½æ°ç¨Countifå½æ°ï¼ç»è®¡ä¸ºç©ºæä¸ä¸ºç©ºå¯ä»¥ä½¿ç¨CountaãCountblankå½æ°ã
ä¸å¾ä¸ºä¾ï¼è¦ç»è®¡A1:B10ä¸ä¸ºç©ºçåå æ ¼æ°
=Counta(A1:B10)
ç»è®¡ç©ºåå æ ¼æ°
=COUNTBLANK(A1:B10)
ç»è®¡æ°ååå æ ¼æ°
=COUNT(A1:B10)
ç»è®¡ææ¬åå æ ¼æ°
=COUNTIF(A1:B10,"*")
ç»è®¡å¤§äº500çæ°ååå æ ¼æ°
=COUNTIF(A1:B10,">500")
ç»è®¡å å«â好âååå æ ¼æ°
=COUNTIF(A1:B10,"*好*")
ç¥è¯æ©å±ï¼
1ãéé 符ï¼*å·è¡¨ç¤ºä»»æé¿çææ¬ï¼?å·è¡¨ç¤ºå个ææ¬ï¼ï½å·è¿æ¥éé 符表示éé 符æ¬èº«ã
2ãCountifå½æ°ç第ä¸ä¸ªåæ°ï¼å¿ é¡»æ¯åå æ ¼å¼ç¨ï¼å¦ä¸è¿°å ¬å¼ä¸çA1:B10ï¼ä¸å¯ä»¥æ¯æ°ç»å¸¸éã
3ãCountifå½æ°æ¯ä¸ªé«è½ä½æçå½æ°ï¼åè½å¾å¼ºï¼ä½ç±äºè®¡ç®ä½¿ç¨éåæ³ï¼æ¯ä¸ªåå æ ¼é½å¿ 须计ç®å°ï¼ï¼å¦=COUNTIF(A1:B10,"*好*")ï¼A1:B10æ¯ä¸ªåå æ ¼é½è¦æ¥çæ¯å¦å å«â好âï¼ä¸è½æä¸ä¸ªåå æ ¼æ¼æï¼å æ¤æçæä¸å®å½±åã