Help with searching for category then adding the value to another cell

Good afternoon! I am playing around with creating a ledger. What I am trying to do is have Excel automatically search for a transaction category (i.e. Gas, Food, Bills, etc...) within a column then add the value of that trans to another cell. This one is blowing my mind. So I want excel to seach Column 2 for the category, then assign the appropriate value in column 3 to one of the cells in G3:I3. Could this be done with functions or is VBA required and how do I set it up?

EX:

.........1............2.........3
A.....Date......Trans.....Amt
B.....12/1.......Gas.....$15.00
C.....12/2.......Food....$6.00
D.....12/2.......Bills.....$37.00
E.....12/3.......Food....$12.25
F......12/4......Bills.....$63.00
G.....Gas Total:..........???
H......Food Total:........???
I........Bills Total:.........???

Thank you for your help!

1) Move your totals out of the same columns you're collecting data in. Much simpler if the data and the totals are kept in separate sections of your worksheet. Plus, you can add data to the bottom of the data columns and the totals will continue to sum.

2) Then use a standard SUMIF() to collect all the items that match the categories.

Sample attached.

Excellent! Thank you very much for your help!