SumProduct, IsNumber, and asterisk

[NightStarLynx]

Hi all,
I am trying to add all numbers in one column IF that row contains a string in a different column, whether it is an exact match or not. (The reference cells are also on another sheet, and the column can be filtered and sorted in all manners).

This formula works great:

=SUMPRODUCT(--(Wife!$J:$J="Phone"),Wife!$D:$D)

The cell containing the category "Phone" is unique, but not all are. Some categories are split, ie "Vending - Work" and "Vending - Entertainment".

I am having trouble getting the sum for ALL of the "Vending" categories, whether the cell is "Vending - Work" or "Vending - Entertainment".

This formula is functional, but gives the wrong sum:

=SUMPRODUCT(--(Wife!$J:$J=(ISNUMBER(SEARCH("Vending*",Wife!$J:$J)))),Wife!$D:$D)

The function above is returning $8,794.50, where it should be $127.35
(All of the charges in that sub-category are between $.75 and $2.10)

Here is a screenshot of the row in question:
Row.jpg

(Brief explanation of the Workbook:
I have all of our Bank transactions listed by account, with dates, descriptions, debits & credits, etc etc
I am trying to find how much we have spent in each category I've assigned to each transaction. Most have been easy, anything to fo with our phones is in the "Phone" category. Yet, other things belong to more than one category. Ie, "Vending - Work" and "Vending - Entertainment". I am trying to figure out our budget for each category, but they need to stay separated in their subcategories because anything we spend on business trips will eventually be reimbursed, but we have to budget for it all in order to have the cash at the time of purchase.)
Column I= Category
Column J= Sub-Category
K= =SUMPRODUCT(--($I:$I="Food"),$D:$D)
L= =SUMPRODUCT(--($I:$I="Food"),$E:$E)
M= =(K14-L14)

Thanks so much!

TL:DR?
How do I use an asterisk within the ISNUMBER(SEARCH function to find all instances of a string of text, when that whole function is also within the SUMPRODUCT function?

[Bob Phillips]

You have over-thought the formula, all you need is

Please Login or Register  to view this content.

[Bob Phillips]

I over-thought it as well, a simple SUMIFS suffices

Please Login or Register  to view this content.

[CAABYYC]

To use "sumif" will be 1 charactor shorter in formula....

[NightStarLynx]

Thank you Bob, the second formula worked! I didn't know the SUMIFS function existed (to use SUMIF, I had to change the formula completely, but it works if there is only one criteria. Thanks CABYYC!)
The first formula isn't accepted (missing a close parenthesis before the ,Wife!$J:$J) but even that corrected, it still gives me the $8,794.50 result. I am still curious to know why my convoluted monstrosity is wrong, though. I've tried it for different criteria, as well, and some result in a much larger number than it should, and some result in a much smaller number.
And to know how to get that darned asterisk to function properly.

Thanks!