Excel Excel 2003 - Count / SumProduct Combine?

[excel2003]

Hi All,

I need assistance in regards to counting a specific "word" in relation to a date range.
Issue - how many times "Car" appears for a date range (3/1/2011 to 3/31/2011)

Column B = text / Column D = Date Range

Ex:
B1 - "Bike Car Red Blue" | D1 - 3/1/2011
B2 - "Frog Balloon" | D2 - 3/5/2011
B3 - "Car Frog Bike" | D3 - 3/21/2011
B4 - "Run Car Book" | D4 - 4/2/2011

Answer is "2"

*Car is in the beginning, middle, sometimes end of a cell"

The formula below works for counting the rows with date range from 3/1/2011 to 3/31/2011
=SUMPRODUCT(--(D21000>=DATE(2011,3,1)),--(D21000<=DATE(2011,3,31)))

But I would like to combine that with the number of times a text occurs (column B) within that date range (column D).

Any assistance is appreciated.

Thanks,

 

[excel2003]

Anyone?