SUMIF function

Assuming that in column B are some spendings of  people listed in column A, let's check how much Kate spent according this table:

	A	B
1	Kate	11
2	Kate	20
3	Mark	35
4	Ben	28
5	Kate	39
6	Mark	33

The formula is:

	A	B
1	Kate	=SUMIF(A1:A6,"Kate",B1:B6)

	A	B
1	Kate	70