Dynamically sum a column

Originally Posted by JOHN H. DAVIS

Maybe:

Range("G" & Range("G" & Rows.Count).End(3)(2).Row).Formula = "=IF(SUM(" & Range("G2:G" & Range("AV" & Rows.Count).End(3).Row).Address(False, False) & ")=0,"""",SUM(" & Range("G2:G" & Range("AV" & Rows.Count).End(3).Row).Address(False, False) & "))"
End Sub

Hi John,

When I try the above code, it total only Column G.