Take a look at the SUMIF function...
=SUMIF(A:A,D1,B:B)
=SUMIF(range,criteria,sum_range)
The range >> column A which includes the type of transaction
The criteria >> cell D1 which in this case equals >> Lunch
The sum range >> column B which holds the amounts you spent on a transaction
Bookmarks