4 1/8/2020 6.78 1887 206406.45 1/9/2020 0.26 1459 3/8/2020 72.16 1423 2/9/2020 97.35 1295 2/10/2020 43.4 1155 3/11/2020 23.02 1215 4/8/2020 18.5 708 4/9/2020 28.06 1900 7/10/2020 12.13 1820 7/11/2020 81.75 1888 4/12/2020 60.56 1395 4/13/2020 76.569999999999993 725 5/14/2020 46.66 996 5/15/2020 2.2799999999999998 1937 5/16/2020 82.62 1920 5/17/2020 50.81 1374 6/18/2020 62.08 727 6/19/2020 39.21 639 数据源: 查询区: 产品 销售额 产品A 产品B 产品C 产品D Excel中用SUMPRODUCT函数实现按指定月份求和 销售日期 销售量 单价 月份 =SUMPRODUCT((MONTH(A4:A21)=$G$3)C4:C21D4:D21)
|
|