Excel 2003 sum function

  • Thread starter Thread starter Josie
  • Start date Start date
J

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
 
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
 
Back
Top