=SUMPRODUCT((A2:A200="å¼ ä¸")*((TEXT($B$2:$B$6000,"e-m")="2016-7")*C2:C2)
åå¤å¹´æåºè¯¥æ¯è¿æ ·å§
ææ´æ¿æåæè¿æ ·ï¼
=SUMPRODUCT((A2:A200="å¼ ä¸")*(YEAR(B2:B200)=2016)*(MONTH(B2:B200)=7)*C2:C200)
å½ç¶ä½ çä¹å¯ä»¥
æ第ä¸ä¸ªåçåéäºï¼æ¯ï¼C2:C200
(YEAR(B2:B200)=2016)*(MONTH(B2:B200)=7) ç¨å¹´æå°±ä¸æ¾ç¤ºæ°å¼äº
追çç¡®å®ä½ çBå为æ¥ææ ¼å¼ï¼
æè¿é使ç¨è¯å¥½