Adding to an existing column

[philky001]

HI I have excel data like this:

VISIT<48 >48 TOTAL BILLED NOT BILLED

10 4 3 7 3

I need a macro that will add the not-billed to the <48 i.e. 3+4= 7.
7 would replace the 4.

I tried C13=C13+F13 but it does not compile.

 

[JLGWhiz]

Assuming your data is in columns B:E

Sub t()
Dim c As Range
    For Each c In Range("C2", Cells(Rows.Count, 3).End(xlUp))
        If c.Offset(, 2) > 0 Then
            c = c.Value + c.Offset(, 2).Value
        End If
    Next
End Sub

This would add the two columns for each row when column E contains a value greater than zero.