I have five columns of data like this:

Col A: State
Col B: County
Col C: City
Col D: Month
Col E: Hours

If A, B, and C all match, I want to sum Col E. So it doesn't matter what D is. I probably won't even show D in the report. I just want one line instead of two or more.

Ex:

Virginia Fairfax Herndon Feb 5
Virginia Fairfax Herndon May 10

Should show:

Virginia Fairfax Herndon       15

I tried grouping but that didn't work. Can anyone help?