求助，来个大神帮帮指导一下，谢谢

daboluo0426

quqiyuan

=SUMPRODUCT((LEFT(J2,2)=$M$2)*($B$2:$B$19=$M$2)*$E$2:$G$19*($D$2:$D$19<=-LOOKUP(-1%,-MID(J2,ROW($1:$10),2))))

yfan17

1. =IF(COUNT(FIND($M$2,$J2)),NPV(-2,SUMIFS($G:$G,$D:$D,"<="&MID($J2,FIND("鞋",$J2)+1,2)+{-10,0},$B:$B,$M$2)),"")

复制代码

daboluo0426

quqiyuan 发表于 2023-6-17 22:43
=SUMPRODUCT((LEFT(J2,2)=$M$2)*($B$2:$B$19=$M$2)*$E$2:$G$19*($D$2:$D$19

大神，求和不对，再帮忙看看呢，谢谢你

daboluo0426

yfan17 发表于 2023-6-17 22:58

大神，你这个只能求和单列，不能3列一起求和

quqiyuan

daboluo0426 发表于 2023-6-17 23:28
大神，求和不对，再帮忙看看呢，谢谢你

=SUMPRODUCT((LEFT(J2,FIND("鞋",J2))=$M$2)*($B$2:$B$19=$M$2)*$E$2:$G$19*($D$2:$D$19<=-LOOKUP(-1%,-MID(J2,ROW($1:$10),2)))*($D$2:$D$19>(-LOOKUP(-1%,-MID(J2,ROW($1:$10),2))-10)))

dim麻辣君

加一个

1. =SUM(SUMIFS(OFFSET(D$2,,{1,2,3},18),B$2:B$19,M$2,D$2:D$19,"<="&LEFT(SUBSTITUTE(J2,M$2,),2)))

复制代码

daboluo0426

求和不对，你这个是总和，不是xx<=xx。还是谢谢你

yfan17

1. =IF(COUNT(FIND($M$2,$J2)),NPV(-2,SUMIFS(OFFSET($D:$D,,{1;2;3}),$D:$D,"<="&MID($J2,FIND("鞋",$J2)+1,2)+{-10,0},$B:$B,$M$2)),"")

复制代码