Home Accounts Formula - Retrieve And Add Data ($) From One Column

I have a category field, and a money spent field in a table.

Category Money spent
1 $12
2 $19
2 $122
1 $5
4 $65
5 $34
5 $12
3 $26

Category 1: $17
Category 2: $$$
and so on..

So I'm looking for a formula that returns information to one cell. A formula that looks if in 'this' column you see the category code '1' for example, then return to me the money spent for ALL the 1's. It should return $17...

The table above is small just for demo purpose, my table has 8 category codes at the moment and the number of rows can be between 15 and 50 I guess... it's a monthly break down.

I would like to see how much is spent in total for each category...

In addition if possible, can this be done for two separate tables... We are two people, and I have two table recording expenditure.

So the formula would need to, from these tables:

Person A Person B
Category Money spent Category Money spent
1 $12 2 $14
2 $192 4 $25
2 $122 4 $65
1 $5 1 $32
4 $65 3 $75
5 $34 3 $85
5 $12 2 $12
3 $26 2 $11

Category 1: $49
Category 2: $$$
and so on...

Look up in both tables, search the two category columns for category '1' for example, then return all the $'s added together... So for Category 1 now it would show $49...