求助：合并单元格，多条件求和

Me-262 · 发表于 2023-6-20 13:16

求助大神，带合并单元格的多条件求和公式
（工单号对应的维修技师、工单类别的应收金额）

solextrade · 发表于 2023-6-20 13:46

=SUMPRODUCT((LOOKUP(ROW($2:$29),ROW($2:$29)/($A$2:$A$29>0),$B$2:$B$29)=$J2)*($D$2:$D$29=M$1)*($E$2:$E$29=$K2)*($G$2:$G$29=$L2)*$H$2:$H$29)

Me-262 · 发表于 2023-6-20 13:55

solextrade 发表于 2023-6-20 13:46
=SUMPRODUCT((LOOKUP(ROW($2:$29),ROW($2:$29)/($A$2:$A$29>0),$B$2:$B$29)=$J2)*($D$2:$D$29=M$1)*($E$2:$ ...

多谢大神！

sxbjzjf110 · 发表于 2023-6-20 14:00

橒♂蝣 · 发表于 2023-6-20 14:19

C2加格式刷=SUM($H$2:$H$29*(XLOOKUP(SEQUENCE(ROWS($B$2:$B$29)),IF(XMATCH($B$2:$B$29,$B$2:$B$29)=2,0,XMATCH($B$2:$B$29,$B$2:$B$29)),$B$2:$B$29,,-1)=B2))

Me-262 · 发表于 2023-6-20 15:21

橒♂蝣发表于 2023-6-20 14:19
C2加格式刷=SUM($H$2:$H$29*(XLOOKUP(SEQUENCE(ROWS($B$2:$B$29)),IF(XMATCH($B$2:$B$29,$B$2:$B$29)=2,0,X ...

谢谢大神！

		自动登录	找回密码
密码			免费注册

[求助] 求助：合并单元格，多条件求和