Home accounts formula help... Retrieve & add data ($) from one column, if category code is

[ChrisWhite1980]

Hi, this is my first usage of this forum, it's been helpful and this one I can't find a solution for.

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...

Thanks for help, it's really appreciated.
Chris.

[Speshul]

=sumif(b1:b50,a1)

Where A1 contains the "1" representing Category 1

[ChrisWhite1980]

Excel.jpg

So I hope the photo uploaded & explains my request a little better perhaps? It seems simple, so I'm sure someone out there is capable...
Obviously not me

[Yogi52o]

=SUMIF(A:A,C3,B:B)

Where C3 is your first criteria (A), and then you could drag down to the others (c4 and then c5).

[oeldere]

or use a pivot table for that kind of work.

then you don't have to worry about all criteria.

[ChrisWhite1980]

Pivot Table. Done - thank you very much.
Cheers,

[oeldere]

Thanks for the reply.

Glad I could help.

Will you mark the question as closed.

[ChrisWhite1980]

I will do, I can't find the button though

[ChrisWhite1980]

Done. Thread has been solved.

I will do, I can't find the button though