Sum data based on cell contents

[Jeff]

Hi All!

I apologize in advance if this is posted in the wrong group, I am
unsure as to which excel group this would be best in.

I export my bank statements into excel each month. They have five
columns:

DATE TYPE DESCRIPTION REF# AMOUNT

I would like to create a formula / function to look for key words in
the description column, and add the corresponding sums in the amount
column. I.E I would like to find out how much money I spent on taco
bell this month

I would truly appreciate any help you can offer. Thanks in advance, and
happy holidays!!!!

-Jeff

 

[Paul B]

Jeff, something like this, with C having Taco Bell and E what you spent put
this in another cell

=SUMIF(C2:C25,"Taco Bell",E2:E25)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Jeff]

Paul,

Thanks so much for your quick response! I tried it and it cam up with a
0. I love my taco bell, so there are lots of entries in the first 25
cells. Not sure why it may not be working. I am using Excel 2002 SP2. I
put the formula in a blank cell at the bottom of my worksheet. Am I
doing it wrong? Thanks in advance.

 

[Paul B]

Jeff, Taco Bell is in column C and the amount is in column E?
Are the cells in column E formatted as text? If so format to something else
and reenter the number
Could there be a space in the cell before or after Taco Bell?

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003