名称 | 数量 | 日期 | 季度 | 合计 | 公式 |
A | 1 | 2016/1/1 | Q1 | 3 | =SUMIFS(B:B,A:A,"A",C:C,">="&DATE(2016,1,1),C:C,"<"&DATE(2016,4,1)) |
A | 1 | 2016/2/1 | Q2 | 6 | =SUMIFS(B:B,A:A,"A",C:C,">="&DATE(2016,4,1),C:C,"<"&DATE(2016,7,1)) |
A | 1 | 2016/3/1 | Q3 | 9 | =SUMIFS(B:B,A:A,"A",C:C,">="&DATE(2016,7,1),C:C,"<"&DATE(2016,10,1)) |
A | 2 | 2016/4/1 | Q4 | 12 | =SUMIFS(B:B,A:A,"A",C:C,">="&DATE(2016,10,1),C:C,"<"&DATE(2016,10,1)) |
A | 2 | 2016/5/1 | |||
A | 2 | 2016/6/1 | |||
A | 3 | 2016/7/1 | |||
A | 3 | 2016/8/1 | |||
A | 3 | 2016/9/1 | |||
A | 4 | 2016/10/1 | |||
A | 4 | 2016/11/1 | |||
A | 4 | 2016/12/1 |
ttyong 发表于 2018-11-19 17:15
DATE可以省略掉
=SUMIFS(B:B,A:A,"A",C:C,">=2016/1/1",C:C,"
欢迎光临 ExcelHome技术论坛 (https://club.excelhome.net/) | Powered by Discuz! X3.4 |