If statement problem

[alimirfarhad]

I want to add the expenses of one person from the given below exce
data.


A...............B...................C
Name........Expense
A...............100
B...............200
A...............50
C...............67
A...............84

I just want to find out total expenses of 'A'. How this can be don
using IF statement or if there is any other solution.


Thanks

 

[Vaughan]

This will work:

=SUMIF(A1:A100,"A",B1:B100)