Simple Money Addition in Categories -- HELP!

[Chenoaem]

I have a spreadsheet that helps me manage my finances that has columns as follows:

A B C D
1 Date - Place - Amount - Category
2 1.1.13 - arco - $35 - GAS
3 1.3.13 - Vons - $56 - FOOD
4 1.4.13 - Ralphs - $34 - FOOD
5 1.6.13 - Chevron - $53 - GAS
6 1.7.13 - Albertsons - $32 - FOOD
etc...

I would like to be able to separate the categories and have excel add the totals from each category like below:

FOOD - $122
GAS - $88
etc....

What is the formula I need to use here?

HELP PLEASE! I know I'm a noob here, but I can't seem to find the answer I'm looking for..

Thank you!!!!

[Pepe Le Mokko]

Hi
one possibility is using a Pivot table
the other
=SUMIF(c2:c100,"food",d1:d100)

[Ace_XL]

Try pivot tables..

see attached

some reading too..
www.cpearson.com/excel/pivots.htm

[martindwilson]

try
=sumif(d2:d100,"food",c1:c100)

[Chenoaem]

That answer gets me a "0". I'm not sure what I did incorrectly.. I want this way to work so badly..

My formula looks like this:
=SUMIF(C2:C100,"food",D1:D100)

What am I doing incorrectly..

[martindwilson]

which column has food in it? that needs to be first
SUMIF(range,criteria,sum_range)

[Kevin UK]

Hi

For SUMIF:
=SUMIF(D1:D100,"FOOD",C1:C100)

But if you are using SUMIFS:
=SUMIFS(C1:C100,D1:D100,"FOOD")