Lookup and add values

[paulcraigdainty]

I want Excel to add up at set of values that correspond to someone’s name. The number of values can vary. The following is how my data looks in Excel:

Dave 25
Dave 30
Dave 42
Paul 35
Dave 9
Paul 44
Paul 78
Dave 4
Dave 21

I want to use some kind of lookup (not sure if I could tailor vlookup to suit this) to add up all values for Dave and all values for Paul and display as follows:

Dave 131
Paul 157

Does anyone know if this is possible and how I might go about achieving this??

 

[jesso]

I dont know if is it a lookup function, but in sql it would be:

select name, sum(points) from students group by name;

 

[paulcraigdainty]

Can i use SQL in Excel though?

 

[Deleted member 30250]

Why can't you sort by name and subtotal?

 

[shades]

Assume data is in columns A:B. Put the name Dave in D1 and Paul in D2. Then in E1 put this formula:

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

Copy to E2
________
CHRYSLER VOYAGER HISTORY

 

[paulcraigdainty]

Excellent! works perfectly, thank you.