求黄色单元格的公式，请大神帮忙，超级感谢

17755004026

剑指E

=SUMPRODUCT(($A$2:$A$30=$A35)*(TEXT($B$2:$L$30,"emm")=TEXT(B$33,"emm"))*ISNUMBER(FIND(B$34,$C$1:$M$1))*$C$2:$M$30)

无聊的黑猫

=SUM(IF(ISNUMBER(FIND(TEXT(IF($B$2:$J$30=B$33,COLUMN($B$2:$J$30),"")+1,"00"),TEXTJOIN(",",1,TEXT(IF(ISNUMBER(FIND(B$34,$B$1:$M$1)),COLUMN($B$1:$M$1),""),"00"))))*ISNUMBER(FIND(TEXT(IF($B$2:$J$30=B$33,ROW($B$2:$J$30),"龙"),"00"),TEXTJOIN(",",1,TEXT(IF($A$2:$A$30=$A35,ROW($A$2:$A$30),""),"00")))),$C$2:$K$30,0))三键 下拉 右拉

良良

猜个：
B35=SUMPRODUCT(($A$2:$A$30=$A35)*(1-ISERR(FIND(CHOOSE(MOD(COLUMN(),2)+1,"立账","付款")&"日期",$B$1:$J$1)))*($B$2:$J$30<=B$33)*$C$2:$K$30)
C35=SUMPRODUCT(($A$2:$A$30=$A35)*(1-ISERR(FIND(CHOOSE(MOD(COLUMN(),2)+1,"立账","付款")&"日期",$B$1:$J$1)))*($D$2:$L$30<=C$33)*$E$2:$M$30)
选中B35:C35，下拉、右拉。

17755004026

剑指E 发表于 2023-3-21 10:21
=SUMPRODUCT(($A$2:$A$30=$A35)*(TEXT($B$2:$L$30,"emm")=TEXT(B$33,"emm"))*ISNUMBER(FIND(B$34,$C$1:$M$1 ...

大神，为什么扩大到10000行 公式就不行

剑指E

17755004026 发表于 2023-3-21 13:05
大神，为什么扩大到10000行 公式就不行

=SUMPRODUCT(($A$2:$A$30000=$A35)*(TEXT($B$2:$L$30000,"emm")=TEXT(B$33,"emm"))*ISNUMBER(FIND(B$34,$C$1:$M$1))*$C$2:$M$30000)

Aleax3

剑指E 发表于 2023-3-21 10:21
=SUMPRODUCT(($A$2:$A$30=$A35)*(TEXT($B$2:$L$30,"emm")=TEXT(B$33,"emm"))*ISNUMBER(FIND(B$34,$C$1:$M$1 ...

TEXT($B$2:$M$30,"emm")=TEXT(B33,"emm"),为啥选择M行就显示错误值呀，选择L行就可以

17755004026

剑指E 发表于 2023-3-21 14:25
=SUMPRODUCT(($A$2:$A$30000=$A35)*(TEXT($B$2:$L$30000,"emm")=TEXT(B$33,"emm"))*ISNUMBER(FIND(B$34 ...

大佬，用你的公式已经完美解决，月份内的立账金额，后面的实际付款金额汇总太难了，因为可能不是当月付的，能帮忙再看看吗？