Sum Formula with Criteria/Match

[Glasgowsmile]

Hello,

Looking for help with a formula.

I've got a spreadsheet that is just names and some numbers next to them. The names show up multiple times so I need the formula to look at each name, pull the number next to it, and sum all the numbers today.

In the example below -- formula should see Don and be able to pull the total of 15 from all the cells.

E.G.

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]Don[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Jon[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Brad[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Don[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]Don[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]

 

[Eric W]

Try:

=SUMIF(A:A,"Don",B:B)

 

[DanteAmor]

You can create a pivot table and get all totals by name.