Not sure I'm completely following as what is to sum? Everything is in the month of June and all values in column A are singular, no duplicates.

Can you update your attachment in D3 with some results?

Immediately I'm thinking a pivot table, but just not sure what you are trying to achieve.