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?

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)

--
Regards,
Fred


"charlenegrelli" wrote in message
...
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?