Excel formula Question

Hi,

I have two columns, one column of names and the other numbers like so...

Alan      43
Alan      33
Alan      0
Andrew      40
Andrew S      305
Andrew S      178
Andy      11
Andy      0
Andy      22
Brendon      216
Brendon      322
Brendon      144
Brendon      4
Brendon      65
Brian      168
Brian      18
Brian      83
Brian      26
Brian      111
Brian      108
Cameron      23
Cameron      41
Cameron      52
Cameron      19
Cameron      95
Cameron      34
Cameron      84
Cameron      13
Cameron      25
Cameron      225
Cameron      49
Cameron      128

What i want to be able to do is at the last entry of each name havea total of all the numbers assoicated with each name. so it would look like this... the figures change every month.

Alan      43            
Alan      33            
Alan      0            76
Andrew      40            40
Andrew S      305            
Andrew S      178            483
Andy      11            
Andy      0            
Andy      22            33
Brendon      216            
Brendon      322            
Brendon      144            
Brendon      4            
Brendon      65            751
Brian      168            
Brian      18            
Brian      83            
Brian      26            
Brian      111            
Brian      108            514
Cameron      23            
Cameron      41            
Cameron      52            
Cameron      19            
Cameron      95            
Cameron      34            
Cameron      84            
Cameron      13            
Cameron      25            
Cameron      225            
Cameron      49            
Cameron      128            788

thanks