Conditional If statement?

[Spajeoly]

This is a weird one, I am helping a friend with a spread sheet that tracks dollar amounts and who handled them basically.

There is a collumn with names in it that have a dollar amount next to them. What we need is for Excel to add up all the dollar amounts in the range according to what name is in the corrisponding collumn.. This is what it lookes like kind of...

I gott do this in VBcode tags or the spaces get jacked....

Name     Amount
 
John      $10,000
Bill        $500
Jody      $3,000         
John     $100
Jody      $50
 
Totals
Name       Total Amount      Amount processed
 
John        $10,100               2
Bill         $500                1
Jody        $3,050                 2

I could do this in VBA but he is not allowed to use VBA for whatever reasons, so this would have all be done with formulas.

We already got the formula to count how many entries there are per name but I can't seem to figure out how the dollar amount could be added up into the total cell going by what name is in the other collumn.

Any help is greatly appreciated, thanx, I will be reading up on the subject in the meantime. Thanx.