EXCEL中求满足年、月、产品,的销量,即三个条件,其中两个条件是满足年...答:使用下列公式之一 =SUMIFS(C:C,A:A,">="&DATE(2020,12,1),A:A,"<="&DATE(2020,2,0),B:B,"A")或 =SUMIFS(C:C,A:A,">="&DATE(2020,12,1),A:A,"<"&DATE(2020,2,1),B:B,"A")或 =SUMPRODUCT((YEAR(A:A)=2020)*(MONTH(A:A)=12)*(B:B="A")*C:C)或 =...