阿帅不必绝情 发表于 2021-12-7 12:58:00

根据sheet1里的条件自动求和

根据sheet1里的条件自动求和sheet2的数据

秦子 发表于 2021-12-18 22:08:21

=SUMPRODUCT(COUNTIF(A2,"*"&Sheet2!A$2:A$34&"*")*Sheet2!B$2:B$34)

潘恒生 发表于 2022-3-5 22:20:49

=SUMPRODUCT(SUMIF(Sheet2!A:A,TRIM(MID(SUBSTITUTE($A2,",",REPT(" ",100)),COLUMN($A$1:$Z$1)*100-99,100)),Sheet2!B:B))

这只是个昵称 发表于 2022-3-6 19:26:33

=SUMPRODUCT((TRIM(MID(SUBSTITUTE(A2,",",REPT(" ",200)),COLUMN(A:J)*200-199,200))=Sheet2!$A$2:$A$34)*Sheet2!$B$2:$B$34)
页: [1]
查看完整版本: 根据sheet1里的条件自动求和