Add Total & Average at Bottom row of ListView And Filter based on criteria

[Faridwahidi]

Hi All,

I have created ListView but not sure how to add total & average at the bottom row of list view.
The total to be added starting from column 10 to 25 whilst The average from column 26 until the last column.

Then, I want to the list be filtered based on criteria in Combobox. The selected criteria must recalculate the Total & Average at the bottom row. Any assistance would be much Appreciated..

Private Sub ComboBoxFilterBC_Change()
End Sub

Private Sub ComboBoxFilterJob_Change()
End Sub

ListView.jpg


Here is my Attachment.