w2001pf 发表于 2013-7-8 11:00
你看是这样的吗?
For i = 2 To 27
Sigma = Sigma + (Range("E" & i) - 100) ^ 2
对的
不过需要完善一下
这样就OK了
Sub 按钮1_Click()
Dim mid As Double
Dim x As Integer
Dim sim As Double
x = WorksheetFunction.CountA(Range("A:A"))
For i = 2 To x
sigma = sigma + (Range("E" & i) - 100) ^ 2
Next