假设日期在sheet1的a列,产值在sheet1的b列。
天数:=SUMPRODUCT((Sheet1!A1:A9999>=--TEXT("2014-1-1","e-m-d"))*(Sheet1!A1:A9999<=--TEXT("2014-1-10","e-m-d")))
产值之和:=SUMPRODUCT((Sheet1!A1:A9999>=--TEXT("2014-1-1","e-m-d"))*(Sheet1!A1:A9999<=--TEXT("2014-1-10","e-m-d"))*Sheet1!B1:B9999)
温馨提示:答案为网友推荐,仅供参考