Excel sum if on the same location

Frequent Contributor


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.

1 Reply


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