|
发表于 2015-11-23 20:55
|
显示全部楼层
本楼为最佳答案
本帖最后由 dsmch 于 2015-11-23 21:02 编辑
Sub Macro1()
On Error Resume Next
h = Selection(1).Row
hs = Selection.Rows.Count
arr = Cells(h, 4).Resize(hs, 4)
ReDim brr(1 To 1, 1 To 4)
For j = 1 To 4
If j <> 2 Then
For i = 1 To hs
brr(1, j) = brr(1, j) + arr(i, j)
Next
End If
Next
brr(1, 2) = (brr(1, 3) + brr(1, 4)) / brr(1, 1)
Cells(h, 4).Resize(hs, 4) = ""
Cells(h, 4).Resize(1, 4) = brr
End Sub
|
|