Multiple occurance lookup and add the values

[Gavin Harrison]

Hi.

Ive tried a couple of formulas to do the below, but don't seem to be able to get one to work. Hoping somebody can help me.

Essentially, I have a column with names (lets say column A) and in column B numbers.

The column with names will have multiple occurances of the same name but may have different numbers next to it.

Essentially I will have a list of the possible names that will occur in column A and next to each name a total of the numbers next to each occurrence of their name.

For Example:

[TABLE="width: 500"]
<tbody>[TR]
[TD]John[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Tom
[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]Barbara[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Tom[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Totals[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]18[/TD]
[/TR]
</tbody>[/TABLE]

 

[Scott T]

Book1
	A	B
1	John	10
2	Tom	5
3	John	8
4	Barbara	3
5	Tom	6
6	Totals
7	John	18
Sheet2

Cell Formulas
Range	Formula
B7	=SUMIF(A1:A5,A7,B1:B5)

 

[Gavin Harrison]

Thank you, i knew i was making it more complicated than it needed to be!