é¦å 请çä¸è¡¨ãAåçæ¥æåï¼å å«å¹´ææ¥çæ¥ææ°æ®ãBåæ¯éå®éã
ç°å¨ï¼è¦åçæ¯ï¼å¦ä½æç §Aåä¸ç年份ï¼æè æ¯æ份ï¼æ±åºæä¸å¹´çéå®éï¼æå¤å¹´ä¸çæ个æçéå®éã
ããä¸ãæ年份è¿è¡ç»è®¡
ããçä¸å¾ï¼å¨C2åå æ ¼ä¸å¯¹åºçFXå ¬å¼è¾å ¥æ¡ä¸ï¼è¾å ¥å¦ä¸å ¬å¼
ãã=SUMPRODUCT((YEAR($A$2:$A$11)=2010)*$B$2:$B$11)
ãã并æå车é®å³å¯ç»è®¡åº2010å¹´çéå®éã
é¨åå½æ°å ¬å¼è§£éï¼
ãã(YEAR($A$2:$A$11)=2010)ï¼è·å年份为2010å¹´ã
ããå ¶ä¸ç$A$2:$A$11ææäºå¹´ä»½æå¨çåå æ ¼èå´ãè$B$2:$B$11åºåæçæ¯æ°æ®æ±åçèå´ã
ããäºãææ份è¿è¡ç»è®¡
ããææ份ç»è®¡ï¼åæ年份ç»è®¡çéçæ¯ä¸æ ·çï¼éè¿å ¬å¼ï¼
ãã=SUMPRODUCT((MONTH($A$2:$A$11)=2)*$B$2:$B$11)
ããå³å¯ç»è®¡åºç»æã
ææç»è®¡ï¼å¾é¾äºè¾¨å«æ份æ对åºç年份ï¼å¦ä¸ç代ç åè½ï¼å·²å¿½ç¥äºå¹´ä»½ï¼åªè¦æ份满足æ¡ä»¶ï¼ä¸ç®¡æ¯åªä¸ªå¹´ä»½ï¼ç»ç»è¿è¡ç»è®¡ã