I'm trying to create a macro because I think that is the only way to do this filter.
What I'm trying to do is total column D, E, and F separate based on cell A, B, and C. I shaded the columns out to make it easier for viewing. ex: Cells A3:A5, B3:B5 and C3:C5 are the same. So in that case I would like to total up column D, E and F in the next columns over for that scenario. Then row 6 switches therefore I need to total those columns up. The results are in red on the attached .xls sheet.

Thx
Mike
Text Excel Forum.xlsx