大佬，求简化

abc123456123

大佬，PPT中的多个sumifs相加，求简化

cutecpu

=SUM(Data!$AB$2:$AH$50000*(LEFT(Data!$D$2:$D$50000,2)="85")*(Data!$E$2:$E$50000='2022 Dec'!$K$2)*(Data!$S$2:$S$50000='2022 Dec'!$K$4)*(Data!$I$2:$I$50000='2022 Dec'!$A559))

祝順心，南無阿彌陀佛！

abc123456123

cutecpu 发表于 2022-12-27 12:39
=SUM(Data!$AB$2:$AH$50000*(LEFT(Data!$D$2:$D$50000,2)="85")*(Data!$E$2:$E$50000='2022 Dec'!$K$2)*(Da ...

大佬，谢谢您，但是我用了，好像不对啊

abc123456123

cutecpu 发表于 2022-12-27 12:39
=SUM(Data!$AB$2:$AH$50000*(LEFT(Data!$D$2:$D$50000,2)="85")*(Data!$E$2:$E$50000='2022 Dec'!$K$2)*(Da ...

abc123456123

cutecpu 发表于 2022-12-27 12:39
=SUM(Data!$AB$2:$AH$50000*(LEFT(Data!$D$2:$D$50000,2)="85")*(Data!$E$2:$E$50000='2022 Dec'!$K$2)*(Da ...

大佬，图片无法显示，您看我加您邮箱您看行不行？

abc123456123

abc123456123 发表于 2023-1-11 15:05
大佬，图片无法显示，您看我加您邮箱您看行不行？

大佬，您看下