Question

excel vba 求和

用vba表达
如果b1=10表示次数,则a3=1,a4=2.....a12=10

c3=a1*b3直到b1所示次数，即c3=a1*b3,c4=a1*b4....c12=a1*b12
d3=c3,d4=c3+c4.....d12=c3+c4+....c12，

Answer 1

Excel怎么求和？这个视频告诉你！

Answer 2

Sub tt()
Dim k As Integer
k = 0

For i = 1 To Cells(1, 2)
Cells(i + 2, 3) = Cells(1, 1) * Cells(i + 2, 2)
Next i

For j = 1 To Cells(1, 2)
Cells(i + 2, 4) = k + Cells(i + 2, 3)
k = Cells(i + 2, 4)
Next j

End Sub