EXCEL 函数 求某段时间区间对应值的和2008-10-1\x051103.62008-11-1\x051136.72008-12-1\x051170.82009-1-1\x051205.92009-2-1\x051242.12009-3-1\x051279.42009-4-1\x051317.72009-5-1\x051357.32009-6-1\x0513982009-7-1\x051439.92009-8-1\x051483.120

EXCEL 函数 求某段时间区间对应值的和2008-10-1\x051103.62008-11-1\x051136.72008-12-1\x051170.82009-1-1\x051205.92009-2-1\x051242.12009-3-1\x051279.42009-4-1\x051317.72009-5-1\x051357.32009-6-1\x0513982009-7-1\x051439.92009-8-1\x051483.120
EXCEL 函数 求某段时间区间对应值的和
2008-10-1\x051103.6
2008-11-1\x051136.7
2008-12-1\x051170.8
2009-1-1\x051205.9
2009-2-1\x051242.1
2009-3-1\x051279.4
2009-4-1\x051317.7
2009-5-1\x051357.3
2009-6-1\x051398
2009-7-1\x051439.9
2009-8-1\x051483.1
2009-9-1\x051527.6
2009-10-1\x051573.5
2009-11-1\x051620.7
2009-12-1\x051669.3
2010-1-1\x051719.4
2010-2-1\x051770.9
2010-3-1\x051824.1
2010-4-1\x051878.8
2010-5-1\x051935.2
求2008-10月至2009年6月的和\x05
求2009年3月至2010年5月的和

EXCEL 函数 求某段时间区间对应值的和2008-10-1\x051103.62008-11-1\x051136.72008-12-1\x051170.82009-1-1\x051205.92009-2-1\x051242.12009-3-1\x051279.42009-4-1\x051317.72009-5-1\x051357.32009-6-1\x0513982009-7-1\x051439.92009-8-1\x051483.120
第一问：
=SUMPRODUCT((A1:A20>DATE(2008,10,0))*(A1:A20