In addition to Rick's solution, you can use your data to create a pivot table
with the locations as row headers, the values in the Value area, and no
column headers

"debd" wrote:

I have data in 2 columns, the first column contains location numbers, the 2nd
column contains values for those locations. Some locations have multiple
values, so they are listed multiple times, (see below)
Location # Value
878 $50,000
879 $22,449
882 $51,050
883 $20,420
884 $10,000
884 $50,000
885 $5,230
885 $20,920
886 $53,764
I need to see the total value for each location, so I need to add the
multiple values for the locations that have them. Is there a formula I can
use to do this and, if so, what is it?

--
Thank you.
debd