I need to loop by row lets say from A1 to E50 and compare values in columns
A,B and D. If those values are the same for two consecutive rows I need to
added and then continue from bottom to top in order to get only one total for
those common values and place them in a different area so i get a summary
section

Here is what I got

For I = LstRowRngXXX To 7 Step -1
If Cells(I, 1).Value = Cells(I - 1, 1).Value And _
Cells(I, 2).Value = Cells(I - 1, 2).Value And _
Cells(I, 4).Value = Cells(I - 1, 4).Value Then
''''''''Add the values and put them somewhere else'''''''''''''Here is
where i need help
End If
Next I

Thanks in advance