Need to get sum with lookup

[Ahmed Fawad]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Expense[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Harry[/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Danny[/TD]
[TD]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Micheal[/TD]
[TD]160[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Harry[/TD]
[TD]28[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tom[/TD]
[TD]22[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Harry[/TD]
[TD]32[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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)