Can't Sum numbers generated by a formula

Hi,

I'm making a quick financial aid to help me keep track of my expenses. I copy my credit cards expense on a line, and then I use this formula to divide my expenses into different groups:

=IF(ISNUMBER(SEARCH("provigo",B2)),D2,"")

So if excel sees "provigo" in the description, it copies the cost manually added into cell B2 in a new cell (D2) under the column title "grocery" to help me know how much I spend on groceries.

Except when I sum all the numbers in the "grocery" column, it gives me 0. No idea why. The cell is defined as currency, and I've tried "Text to columns" option (maybe incorrectly) and it doesn't work. See attached excel.

Thanks in advance.

[QUOTE=FDibbins;5551442]1. Starbucks has a trailing space - remove it.
2. Make up a list of items to test against for col E extract, (I used col L)...make sure you use the same (full) names)

Hi Thanks for your response. My only problem with this (I think), is the same I would face with Alan's response: I would need the exact full names, but I usually don't have them. For example, every starbucks store usually has a unique number (starbucks 384475, starbucks 323958, etc), which is why I would need the formula to look only for "starbucks". Does that make sense?

Sorry my excel example did not show that.

Hi Alan, thanks for taking the time. See my response to FDibbins below. In short, to use your formula, I would need to know the exact name of every transaction for the IF THEN formula to find it, but in most cases I don't know the exact name, only a word within it.

Change the formula in E2 to:

=IF(COUNT(SEARCH({"five","rotisserie","starbucks","hortons","pizza","BEN&"},B2)),D2,"")

Yes! Thank you very much phuocam !!

Set up the criteria in separate tables: EatingOut, Grocery and Car, then use the following formulas:

Cell E2: =IF(ISNA(LOOKUP(1E+100,SEARCH(EatingOut,$B2),EatingOut)),"",$D2)
Cell F2: =IF(ISNA(LOOKUP(1E+100,SEARCH(Grocery,$B2),Grocery)),"",$D2)
Cell G2: =IF(ISNA(LOOKUP(1E+100,SEARCH(Car,$B2),Car)),"",$D2)

then copy down.