累加求和问题

weiguidun

B列能不能用一个数组公式算出来，相当于直接在B3填一个公式，不用下拉

沈默00

=SUM($A$2:$A2)

jerrike

1. =SCAN(A2,A3:A11,LAMBDA(a,b,a+b))

复制代码

hugeinfo

=SCAN(0,A2:A11,LAMBDA(x,y,x+y))

无关岁月

1. =SCAN(0,A2:A11,SUM)

复制代码

祝洪忠-

=SUBTOTAL(9,TAKE(A2:A11,ROW(2:10)))

咔咔乱坠

解1(渣渣)

1. =MMULT(N(ROW(1:10)>=SEQUENCE(,10)),A2:A11)

复制代码

解2(凤凰)

1. =SUMIF(TAKE(A2:A11,ROW(1:10)),"<>")

复制代码

解3(诗佬)

1. =PROB(ROW(A2:A11),A2:A11/SUM(A2:A11),1,ROW(A2:A11))*SUM(A2:A11)

复制代码

解4(萝莉)

1. =REDUCE(,A2:A11,LAMBDA(x,y,VSTACK(x,TAKE(x,-1)+y)))

复制代码