Excel 2007 : Lookup word and sum and values

I am trying to make a budget where I have a sheet of my source data, basically a list of the date, category, and amount of all my expenses. In another sheet I have make a budget of what I want to spend with the exact replica next to it except I want to have the number of what I actually spend in each category. So heres my problem... I want to write a formula that is very similar to a vlookup where I can say every time the word "lunch" comes up in my source data go one cell over and put the amount into my budget. However, as Im sure you can imagine I eat lunch everyday and there for do NOT have unique IDs for all my inputs. So I guess what I real want is a type of lookup where it finds every time the word "Lunch" shows up and sums them for a total amount spend on Lunch in my budget. Can anyone think of an easy way to do this. Thanks guys.
""

hi Excel Question, welcome to the forum. i think you might find SUMIF useful in your scenario,
=SUMIF(Range where you can find the word "Lunch","Lunch",Range you want to sum up)

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

You are most welcome and now you are a forum pro...

Glad it worked out for you and thanks for the feedback

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save