Need help with a sumif using search text function

[silverback24]

I have a feeling I will need to do this with a macro. But either way I am currently stumped.

My data sheet looks something like this:
B C D

# SOLD IN 2013	Rank	Fits All
552	1	Infiniti G35 2002 - 2004 - 2WD or AWD Models with Standard
544	2	Infiniti EX35 2008 - 2012<BR><BR>Infiniti G25X 2011 - 2012 "X"
505	3	Chevrolet Astro 2003 - 2005<BR><BR>Chevrolet Silverado
481	4	Honda Civic Coupe 1993 - 2000 DX or HX
476	5	Acura Integra 1994 - 2001 (Excluding Type R!)<BR><BR>Honda
447	6	Honda Civic Coupe 1996 - 2000 EX Models<BR><BR>Honda
418	7	Ford Excursion 2000 - 2005 4WD Models Only <BR><BR> Ford
412	8	Cadillac Escalade 2007 - 2012<BR><BR> Chevrolet Avalanche
411	9	Ford Mustang 1999 - 2004 Base or GT (Excludes Cobra and GT
397	10	Dodge Durango 2004 - 2006<BR><BR>Dodge Ram 1500 2002

<colgroup><col><col><col></colgroup><tbody>
</tbody>

I have a list of all the makes we sell parts for on another sheet say column A.
I would like to have a function like sumif search for the make in the fits all and add the # sold in 2013 for a total sold per make. Column A is our SKU and wont help in this part. The fits all can be quite long due to it containing between 1 and 20 cars listed inside.

Potentially use same formula to search by model of car also afterward if this works.

Thank you for any help.

 

[silverback24]

I can do this manually by using filter and sum but would like to find a faster way that my coworkers and managers might actually use.

 

[a11jks]

Would you be willing post a copy of the workbook somewhere, and walk me through how you calculate this by hand step by step?

You can fake what some data looks like if needed to keep confidentiality.

 

[silverback24]

Figured it was a good idea to post the solution I found for this problem.

I ended up using wildcards in my sumifs statement

Ex. "*"&search criteria&"*"

This will search in the body of the text in the cell and return true if criteria is anywhere in there. Remove front "*"& for searching cells that begin with your criteria, remove &"*" for searching cells that end with your criteria.
can use typed in criteria or a cell reference, which I used.