本帖最后由 0126 于 2019-11-7 21:54 编辑
A14 =EOMONTH($A$1,ROW(A1)-1)
B14 =IF(MONTH($A14)=1,VLOOKUP(B$11,$B$4:$G$8,5,0),E13)
C14 =SUMIFS(加油明细!$H:$H,加油明细!$A:$A,B$11,加油明细!$D:$D,">="&$A14-DAY($A14)+1,加油明细!$D:$D,"<="&$A14)
D14 =SUMIFS(加油明细!$F:$F,加油明细!$A:$A,B$11,加油明细!$D:$D,">="&$A14-DAY($A14)+1,加油明细!$D:$D,"<="&$A14)
E14 =SUM(B14:C14)-D14
后面的选取前面区域复制过去就行
|