Lookup function used to return multiple values corresponding to a specific word in a table

[suspekt]

Hi guys,

I have been searching for an answer to my problem for days, nothing seemed specific to what i am looking for so i thought i would try asking some experts!

I am making a budget for myself, I am also making a transaction statement in excel which records every transaction i make on my bank account.

I am recording the Date, What the transaction was for e.g. (food), Credit, or debit and then finally the total.

E.g.

Category Credit Debit
Food 11.00
Food 13.00
Drink 5.00
Drink 6.00



Now I can use a vlookup function which works but that only finds the one value in the table, to the right of the tranaction table i have a totals table for each month.

E.g Food = ---
Drink = --- Basically i want a function that will go through my transactions table and find Food and return 24.00 instead of the single values 11.00 or 13.00.


I hope someone can help, im trying to learn more about excel but it can be very tricky for newbies.

Any help received would be greatly appreciated.

Cheers

[humdingaling]

use sumif
http://www.techonthenet.com/excel/formulas/sumif.php

[suspekt]

Perfect, Thank you so much you're a legend!