Index and Match help needed

Hi,
I have a spreadsheet with budget information. I want to use that sheet to populate a different one that will combine all the codes for all the locations into one line. I assume I need Index and Match for this.
For example, I may have loc 1 with 6410.1000 for $50.00 and loc 2 with 6410.1000 for $100.00 and so on the new sheet I want 6410.1000 to show $150.00 total.
There will be many entries to this.
I attached the spreadsheet with the data. The blue cells show where there are multiple account codes for multiple locations which are what I want to combine into one line on a new sheet.
Thank so much...don't know what I would do without this site.