Total by location

[howardjo]

Morning,

I have attached a simple example of what I am trying to achieve.

In the example, I have a list of shops. Each shop shows its location and revenue.

What I need is a generic formula which will Sum all the revenue in the same location. I.e. Eastleigh = £200

However, in the actual document there maybe upto 100 different locations, and these may change on a daily basis.

Therefore, I am looking for Excel to identify all the locations which are the same and Sum the corresponding revenue. In a document which potentially has a changing number of locations.

Many thanks

Howardjo