累积求和

cnmyxk

求L列和M列与天数计算后，累积求和，数组相乘不太会。如附表中是不是有更好的方法去做，我做得太笨了。
总感觉是不是应该用sumproduct()去做，或者sum()就能做。

edwin11891

L2:

1. =SUM(B2:K2/TRANSPOSE(SEQUENCE(10)))

复制代码

M2：

1. =IFERROR(SUM(B2:K2*TRANSPOSE(SEQUENCE(10)))/SUM(B2:K2),0)

复制代码

miaojohn45

=SUM(B2:K2/COLUMN(A:J))

=IFERROR(SUM(B2:K2*COLUMN(A:J))/SUM(B2:K2),0)

E学子

1. =SUMPRODUCT(B2:K2,1/DAY($B$1:$K$1))

复制代码

1. =IFERROR(SUMPRODUCT(B2:K2,DAY($B$1:$K$1))/SUM(B2:K2),0)

复制代码

part98

1. =SUM(B2:K2/SEQUENCE(,10))

复制代码

1. =IFERROR(SUM(B2:K2*SEQUENCE(,10))/SUM(B2:K2),0)

复制代码

mykitami

=SUM(B2:K2/DAY($B$1:$K$1))
=IFERROR(SUM(B2:K2*DAY($B$1:$K$1))/SUM(B2:K2),0)

我的城市你来过

=ROUND(SUM($B2:$K2/COLUMN($A$1:$J$1)),4)