Sub test()
Excel.Application.ScreenUpdating = False
Dim arr
Dim mx
Range("i8").ClearContents
mx = Cells(Rows.Count, 3).End(xlUp).Row
arr = Range("c3:c" & mx)
For i = 1 To UBound(arr)
If IsNumeric(arr(i, 1)) Then
Range("i8") = Range("i8").Value + arr(i, 1)
End If
Next
Excel.Application.ScreenUpdating = True
End Sub
Sub test()
Excel.Application.ScreenUpdating = False
Dim arr
Dim mx
Range("i8").ClearContents
mx = Cells(Rows.Count, 3).End(xlUp).Row
arr = Range("c3:c" & mx)
For i = 1 To UBound(arr)
If IsNumeric(arr(i, 1)) Then
Range("i8") = Range("i8").Value + arr(i, 1)
End If
Next
Excel.Application.ScreenUpdating = True
End Sub