每周采购量求和 (10613)

G2=IF(E2>0,SUM(F$2:F2)-SUM(G$1:G1),"")

另解=IF(E2>0,NPV(-2,SUMIF(C:C,">"&C2-{0,7},F:F)),"")

另解=IF(E2>0,SUM(OFFSET(F2,,,-MIN(7,ROW()))),"")