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.

A	B
Don	5
Jon	3
Brad	3
Don	8
Don	2

<tbody>
</tbody>

 

[Eric W]

Try:

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

 

[DanteAmor]

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