Set up automatic addition of money for corresponding names.

Hi All,

The situation is as follows; everyweek certain members give me a sum of money (£5) and I input this into a table containing three collums 1. Date 2. Name 3. Amount

For Instance

Date Name Name Amount
31/08/2010 Mark £5.00
31/08/2010 John £10.00
01/09/2010 Mark £15.00

What I want excel to do is to recognise that Mark has paid in an amount of money and to add this to the total that the person has paid. For instance upto 01/09/2010 Mark has paid £20.00. Is there a way that Excel can recognise the name and add the total as I will be inputting many different names.

Hi,

Try SUMIF

=SUMIF(B1:B100,"Name",C1:C100)

Sorry, there was a typo in my original post.

In your example sheet, in cell G5, enter

=SUMIF(B2:B4,"Mark",C2:C4)

and in G6,

=SUMIF(B2:B4,"John",C2:C4)

It should be fine. Make sure you have no spaces in the new entry, if that doesn't work, can you post the non-working example?