how to reconcile multiple names for same customer

[charlenegrelli]

I receive a large spreadsheet that is a combination of reports from multiple
distributors. Each distributor lists customers with slightly different
names, and then their total sales to that customer.

Example customer names:

Danaher, Danaher Industrial, Danaher Chemical, Danaher industries, etc. I'd
like to automatically sum the sales to all of the *Danaher*.

How do I go about?

 

[Fred Smith]

This is why customer numbers were invented.

However, it you have no choice but to use the name, you can work with Sumif, as
in:

=sumif(A:A,"*danaher*",B:B)