Wow! It worked! Thank you sooooooo much!!!!!!!!
:-)

"Jacob Skaria" wrote:

Suppose

C1 = Jack
Enter the below formula in D1 and copy down as the number of entries in
Column C

=SUMIF(A:A,C1,B:B)

If this post helps click Yes
---------------
Jacob Skaria


"NZuser" wrote:

Hello,
I have a worksheet that has the following information:
Cell A: Name/Cell B:Amount/Cell C:Name/Cell D:Total
Jack $2 Jack
Bob $5 Bob
Jack $7 Mary etc
Mary $10
Each time an amount is allocated to Jack I would like the amount to go into
the total cell (Cell D)for him, and add it up, or even into another
worksheet, is this possible?
Kind regards
:-)