Private Sub Worksheet_Change(ByVal Target As Range)
Dim x, total
For x = 8 To 12
total = Application.WorksheetFunction.Sum(Range("a" & x & ":d" & x))
If total <> 0 Then
Range("e" & x).Value = total
Else
Range("e" & x).Value = ""
End If
Next x
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Dim x, total
For x = 8 To 12
total = Application.WorksheetFunction.Sum(Range("a" & x & ":d" & x))
If total <> 0 Then
Range("e" & x).Value = total
Else
Range("e" & x).Value = ""
End If
Next x
End Sub