Excel sum if on the same location

Hi,

Looking for an excel formula method to sum and combine stock no/Name of the same Location but not using a Pivot table. See attached example with the results from a Pivot table.