How To Create A Roll Up Table In Excel

Now my issue is I have a spreadsheet with 13000 locations and I need to roll up the duplicate addresses into 1 address with the summation o...