Excel sum if on the same location

[A_SIRAT]

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.

[#2]

@A_SIRAT 

See the attached version. Requires Microsoft 365 or Office 2021.