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:

John	10
Tom	5
John	8
Barbara	3
Tom	6
Totals
John	18

<tbody>
</tbody>

 

[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!