>>can i add the sum total of the column in the footer of listview?
If "footer" is the "header" Or "ColumnHeader", then see if this helps.
With ListView1
.Columns(0).Text = "ListView1" '// Column1
.Columns(1).Text = ".Count" '// Column2
End With