å¾å¤å½æ°é½æ¯æ跨工ä½è¡¨è¿ç®çï¼ä½¿ç¨æ¹æ³æ¯ï¼
1ãå¨éè¦ç»æçå°æ¹è¾å
¥å½æ°ï¼æ¯å¦ï¼=countifï¼ç¶åç¹å»ç¼è¾æ ç FX æé®ï¼å¯å¨ç¼è¾çé¢ï¼
2ãç¶åå¨è¾å
¥åºåçæ¶å使ç¨é®çç CRTLæshifté®éæ©å¤ä¸ªå·¥ä½è¡¨ï¼ç¶åéæ©å
¶ä¸ä¸ä¸ªå·¥ä½è¡¨çæä¸åºåï¼è¿æ¶åææ表åæ ·åºåé½è¢«éä¸äºï¼ï¼å½¢æçå
¬å¼å¦ä¸
=COUNTIF(Sheet2:Sheet5!A2:A7,"ä¸åæ ¼")
3ãå车ï¼ç»æå
¬å¼è¾å
¥ã
追é®æä¹æ¯è¿ä¹å¼çï¼å¯æ¯è¿åå
¬å¼é误
追çè¯äºä¸ï¼ç¡®å®å¼éäº countifä¸è½ç´æ¥è·¨å·¥ä½è¡¨è®¡ç®ï¼è¯è¯åèè¿ä¸ªï¼
=SUM(COUNTIF(INDIRECT("SHEET"&{7,8,9}&"!A1:A10"),"ä¸åæ ¼"))
è¿ä¸ªå¯ä»¥åSHEET7ã8ã9 A1å°A10ä¸ç ä¸åæ ¼ æ°éã