Try it like this:

Entered in B2 then copied down:

=SUMIF(C$2:C$100,A2,D$2:D$100)

--
Biff
Microsoft Excel MVP


"DMB" wrote in message
...
Ok I have the follwing:

Col A Col B Col C Col D

Bill Scott $50
Jim Scott $98
Smith Jack $509
Jill Jack $987
Jack Bill $989
Scott Bill $32


I am trying to do this:

Ok I have the follwing:

Col A Col B Col C Col D
Add Totals
For Each Name
Bill Scott $50
Jim Scott $98
Smith Jack $509
Jill Jack $987
Jack Bill $989
Scott Bill $32

I am using this formula =SUMIF(C2:C100,"Scott",D2:D100). That part works
fine. But what I need to do is be able to get what in in Col A where
Scott
is so that I can drag my formula down so that it will pull the value from
Col
A. I have over 100 names and to type the name in the formula for each
person
is too much. Any ideas on this one?

Thank you.