仅根据附件上的数据猜的,
Sub Macro1()
For i = 3 To 7
s = Val(Cells(i, 1)) + Val(Cells(i, 2)) + Val(Cells(i, 3))
Cells(i, 5) = Cells(i - 1, 5) + s
If Cells(i - 1, 2) = "" And Cells(i - 1, 3) = "" And i > 3 Then
Cells(i, 4) = Cells(i - 2, 5)
Else
Cells(i, 4) = Cells(i-1, 5)
End If
Next
End Sub
Sub tt()
arr = [a2:e7]
For i = 2 To UBound(arr)
If Len(arr(i - 1, 2) & arr(i - 1, 3)) > 0 Then x = i - 1
If i = 2 Then arr(i, 4) = arr(i - 1, 5) Else arr(i, 4) = arr(x, 5)
arr(i, 5) = Val(arr(i - 1, 5)) + Val(arr(i, 1)) + Val(arr(i, 2)) + Val(arr(i, 3))
Next
[a13:e18] = arr
End Sub