ä½ è¿ä¸ªé®é¢æ好ä¸ç¨sumifï¼èç¨å ¶ä»å½æ°æ¥è§£å³(å设Bï¼Fåçæ°æ®å°200è¡ï¼ï¼
=SUMPRODUCT((MONTH(B$2:B$200)=H2)*C$2:C$200)
ä¸è¬å¨è½ç¡®å®æ°æ®çæ åµä¸ï¼æ好ä¸è¦ç¨æ´ä¸ªåè¿æ ·çå½¢å¼ï¼è½ç¶ç¾åº¦å¾å¤äººåçé®é¢å¾çäºä¹ä¼ç¨æ´åï¼ï¼è¯æ³ä¸ä¸ï¼æ¬æ¥Excelè¦ç¨å½æ°å»è®¡ç®å è¡ãå åè¡ãå ç¾è¡ï¼æå¤ä¹å°±å åçï¼ä½ å´å¨å ¬å¼è¦å®å¤è®¡ç®ç¾å¤ä¸è¡ç©ºæ°æ®ï¼æå¿ è¦åï¼è½ç¶å¯è½æè§ä¸å°å¤è®¡ç®ç©ºæ°æ®ä¼å¢å å¤å°æ¶é´ï¼ä½ççå½å ¬å¼å¤ææ¶ï¼å·®å«å°±ææ¾äºã
ä½ çå ¬å¼ä¸å¦å¤è¿æçé®é¢æ¯ï¼sumifä¸ç¬¬2åæ°ä¸è¬åºè¯¥æ¯ä¸ä¸ªåå æ ¼ï¼I2åå æ ¼ä¸çå ¬å¼æ¾ç¶åºè¯¥æ¯H2ï¼å°±æ¯Aåä¸çæ°æ®ä¸H2æ¶ï¼å¯¹Cåæ°æ®æ±åï¼ç°å¨ç¨Hï¼Hå第2åæ°ï¼å ¬å¼å¾å°çç»æå°æ¯Aåä¸æ»¡è¶³æ¡ä»¶HåçCåæ±åï¼æ¯ä¸ä¸ªç¾å¤ä¸è¡ä¸ªæ°æ®çæ°ç»ï¼èå´éè¦çåªæä¸ä¸ªï¼ä¸ºä»ä¹è¦å¤è®¡ç®ä¸ç¾å¤ä¸ä¸ªå¹¶ä¸éè¦çæ°æ®å¢ï¼
为äºè¯´æä¸é¢æ说çï¼ä¸å¦¨åå个ç®åç模æï¼å§ä¸ä¸ºäºä¾¿äºè§çåæææï¼å¦å¾ï¼I2ä¸æä½ çæç»´æ¹å¼æ¥è¾å ¥å ¬å¼ï¼ä½è¿å¹¶ä¸ç¨æ´åï¼åªå¤ä¸äºç©ºç½è¡ï¼æ°æ®åªå°ç¬¬30è¡ï¼ä½å ¬å¼ä¸åå°ç¬¬40è¡ï¼
I2=SUMIF(B2:B40,H2:H40,C2:C40)
å¾å°æ£ç¡®ç»ææ¯æ²¡é®é¢çï¼ä¸é¢æªå¾æ¯æ£ç¡®çåæ³ï¼
I2=SUMIF(B2:B30,H2,C2:C30)
è¿å¯ä»¥
I2=SUMIF(B2:B30,H2,C2)
åé¢çæ±ååºååæ°åªåä¸æ¡ä»¶åºå对åºç第1个åå æ ¼ï¼Excelä¼èªå¨æ©å å°ä¸æ¡ä»¶åºåç¸åçèå´ã
ç°å¨éè¿å¨å
¬å¼ç¼è¾æ ä¸æ¥çå
¬å¼è¿ç®æææ¥éªè¯ä¸é¢æ说çå¤è®¡ç®äºæ ç¨æ°æ®ãå¨å
¬å¼ç¼è¾æ ä¸æé¼ æ éæ©å
¬å¼ï¼å·å³ä¾§çææå
容ï¼ä½¿ä¹åè²ï¼
å¾ä¸è¿å¯çå°å¤éæ©ç空ç½æ°æ®è¡è¢«éæ©äº
ä¸å¾ä¸å ¬å¼è¢«æéåï¼æF9ï¼å°±å¯çå°å ¬å¼è¿ç®çä¸é´ç»æï¼
çå°äºåï¼è¿ç®æ¶çæHåçæ°æ®ï¼åå«sumifäºï¼åé¢åæ¯0ï¼å¦æå
¬å¼åçæ¯B:BãC:CãH:Hè¿æ ·çæ´åï¼åé¢å°±ä¼æ100å¤ä¸ä¸ªæ¯«æ æä¹ç0ï¼åé¢ä¹æä¸ä¸ª0ï¼å¯¹åºç¬¬1è¡ï¼ãèè§èçæ åçåæ³ï¼åç²¾åå°å»è®¡ç®æéè¦çé£ä¸ªæ°æ®ï¼è¿ç®æçæé«çåæ°æ¯ç¾ä¸çº§çï¼èªå·±ä¸å¦¨å»éªè¯ä¸è§èåæ³çè¿ç®ä¸é´ç»æã