Conditional Sum (with several imbedded)

I have a list of customers and their revenue contribution. Some of the customers have multiple entries as shown attached file


I want to input formulas that will do what I've shown above: (1) add together the revenue numbers for customers will multiple entries (so that it shows the sum for the first time the name appears but zero each time after), (2) just list the revenue for customers with single entries. The one catch is that even for customers with multiple entries, the names aren't always exactly the same but the first several characters are. Can anyone advise?


Thanks,

Eric

Originally Posted by Liquifiber

The one catch is that even for customers with multiple entries, the names aren't always exactly the same but the first several characters are.

Eric, you will need to elaborate... how many characters do you want to use to determine a *match* ... ?
In general terms what you're trying to do is relatively straightforward... but we need to know the logic you wish to employ regards partial matches.

OK, ignoring issues of inconsistencies things are pretty straightforward, such that:

Please Login or Register  to view this content.

If you do want to handle *like* matches let us know... it will be a little more convoluted were the partial match ever to be listed first.... if not you could try:

Please Login or Register  to view this content.

Without a bigger source it's hard to comment... and I very much doubt that the above would prove 100% successful.