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(--(D2
1000>=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,
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(--(D2
1000>=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,