Need to get sum with lookup

[Ahmed Fawad]

Name	Expense
Harry	10
Danny	30
Micheal	160
Harry	28
Tom	22
Harry	32

<tbody>
</tbody>

I need to get total expenses of Harry. Plese help

 

[etaf]

is it just harry or other names ?

use a sumif()
or a pivot table

in a new cell say D2 put Harry
in E2 put
=Sumif(A:A,D2,B:B)
of if its only going to be harry
=Sumif(A:A,"harry",B:B)