张帅律师 发表于 2021-11-3 16:43:00

条件多列乘积求和

条件多列乘积求和，请大师帮看下，谢谢

返朴归真 发表于 2021-11-15 22:16:35

=SUMPRODUCT($B$2:$B$11*$C$2:$C$11*$D$2:$D$11*($A$2:$A$11=F4))

小茶壺 发表于 2021-12-25 05:33:50

=SUMPRODUCT(B$2:B$11*C$2:C$11*D$2:D$11*(A$2:A$11=F4))

秦昭王 发表于 2022-2-1 12:03:17

=SUMPRODUCT(($A$2:$A$11=F4)*($B$2:$B$11*$C$2:$C$11*$D$2:$D$11))
页: [1]
查看完整版本: 条件多列乘积求和