Hi Buddy

Unless there is a good reason to summarise the information on another sheet,
this sounds like a job for subtotals.

Open help and search for "Overview of subtotals in lists". It will explain
the concept far better than I could.
If you find yourself struggling or need to do it another way, just ask.

HTH
Steve


"BuddyB" <BuddyB.1kj47m@excelforum-nospam.com> wrote in message
news:BuddyB.1kj47m@excelforum-nospam.com...
>
> I'm sure this is an easy one for all the experts, but I'm just learning
> this stuff and have racked my brains and can't figure out an easy
> way....
>
> On Sheet 1, Column B I have up to 200 names ("B1:B200"), many name
> repeats.
> also on sheet 1, Column E, I have earnings ("E1:E200") beside their
> names
>
> What I need to do is:
>
> On Sheet 2: copy the individual names (just once) and add all their
> earnings together for a total earned.
>
> Thanks in advance for the help
>
> Buddy
>
>
> --
> BuddyB
> ------------------------------------------------------------------------
> BuddyB's Profile:
> http://www.excelforum.com/member.php...o&userid=17694
> View this thread: http://www.excelforum.com/showthread...hreadid=345757
>