我有个EXCEL公式不知道问什么不能显示值答:=SUMPRODUCT((A2:A100>=DATE(2010,7,5))*(A2:A100<=DATE(2010,7,8))*(D2:D100="125*9")*(C2:C100="A1")*(F2:F100))或 =SUM(IF(A2:A100>=DATE(2010,7,5),IF(A2:A100<=DATE(2010,7,8),IF(C2:C100>="A1",IF(D2:D100="125*9",F2:F100),0)))按三键结束 日期格式...