有大佬在么？这个时间条件怎么进销量合计的判断，，产品ABC各

I2=SUMPRODUCT(($B$2:$B$21="甲")*($C$2:$C$21=$H2)*($E$2:$E$21>=MINIFS($E$2:$E$21,$B$2:$B$21,"甲",$C$2:$C$21,$H2))*($E$2:$E$21<=MINIFS($E$2:$E$21,$B$2:$B$21,"甲",$C$2:$C$21,$H2)+45)*($D$2:$D$21)) 下拉
I6=SUMPRODUCT(($B$2:$B$21="乙")*($C$2:$C$21=$H6)*($E$2:$E$21>=MINIFS($E$2:$E$21,$B$2:$B$21,"甲",$C$2:$C$21,$H6))*($E$2:$E$21<=MINIFS($E$2:$E$21,$B$2:$B$21,"甲",$C$2:$C$21,$H6)+45)*($D$2:$D$21)) 下拉
J2=SUMPRODUCT(($B$2:$B$21="甲")*($C$2:$C$21=$H2)*($E$2:$E$21>MINIFS($E$2:$E$21,$B$2:$B$21,"甲",$C$2:$C$21,$H2)+45)*($D$2:$D$21)) 下拉
J6=SUMPRODUCT(($B$2:$B$21="甲")*($C$2:$C$21=$H6)*($E$2:$E$21>MINIFS($E$2:$E$21,$B$2:$B$21,"甲",$C$2:$C$21,$H6)+45)*($D$2:$D$21))

i2=sumifs(d:d,a:a,lookup("座",g$2:g2),c:c,h2,f:f,"<"&index(f:f,match(lookup("座",g$2:g2)&h2,b$1:b$99&c$1:c$99,)+45))数组公式
j2=sumifs(d:d,b:b,lookup("座",g$2:g2),c:c,h2)-i2

I2=SUMPRODUCT(($B$2:$B$21="甲")*($C$2:$C$21=$H2)*($E$2:$E$21<=MINIFS($E$2:$E$21,$B$2:$B$21,"甲",$C$2:$C$21,$H2)+45)*($D$2:$D$21))
I6=SUMPRODUCT(($B$2:$B$21="乙")*($C$2:$C$21=$H6)*($E$2:$E$21<=MINIFS($E$2:$E$21,$B$2:$B$21,"甲",$C$2:$C$21,$H6)+45)*($D$2:$D$21))
不好意思，2楼画蛇添足了