Excel 2003 sum function

[Josie]

How do i identify a nmae from a list in column A and then get the sum of all
the values against that nmae in column b to display a total for each nmae in
column c

 

[Mike H]

Hi,

Select your list of names in column A and then

Data|Filter|Advanced filter

Select 'copy to another location'
Check 'Unique records only'
In the copy to box enter (say) $d$1

OK

This will give you a unique list of names in D1 down. Put this in E1 and
drag down

=SUMIF($A$1:$A$40,D1,$B$1:$B$40)

Change the range to match your data range in columns A & B

Mike

 

[Josie]

Thanks for that. Its worked brllliantly.