Formula that returns the count of items that meet two criteria

[Autumninked]

I'm hoping someone can help me because I've been searching the web and beating my brain over this for a day now.

I have a spreadsheet where I need a formula that will count how many sites have a document type "Lease Review" that are due between 9/1/14 and 9/30/14 only. The result that should come back is "2", but I can't seem to get any formulas I have found to work out correctly. A sample of what I'm working with is below. Any help would be greatly appreciated.

Site #	Lease Document Type	Received Forecasted
E243	MOL	2/3/2014
E245	MOL	5/1/2014
E246	Lease Review	10/4/2014
E247	Lease Review	n/a
E251	Lease Review	11/15/2014
J059	Lease Review	n/a
J082	Lease Review	n/a
J083	Lease Review	n/a
M088	Lease Review	2/1/2014
M090	MOL	9/2/2014
P308	Lease Review	n/a
P325	Lease Review	n/a
P327	Lease Review	n/a
P414	Lease Review	n/a
P415	Lease Review	n/a
P442	Lease Review	5/1/2014
P480	Landlord Notification/Consent	6/30/2014
P517	Lease Review	6/30/2014
P526	Landlord Notification/Consent	2/1/2014
S024	Lease Review	n/a
S028	Lease Review	8/12/2014
S029	Lease Review	10/1/2014
S030	Lease Review	9/6/2014
W031	Lease Review	7/26/2014
W033	Lease Review	9/6/2014

<COLGROUP><COL style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2523" width=69><COL style="WIDTH: 110pt; mso-width-source: userset; mso-width-alt: 5339; mso-outline-level: 1" width=146><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145; mso-outline-level: 1" width=86><TBODY>
</TBODY>

 

[Jonmo1]

Welcome to the board..

Try

=SUMPRODUCT(--(B2:B100="Lease Review"),--(TEXT(C2:C100,"mmyy")="0914"))

 

[Autumninked]

I will give it a try and do a few test runs on it and let you know. I've never used TEXT before and haven't seen any formulas that included it, so I never even considered it. Thank you!

 

[Autumninked]

This worked, thank you!!

Welcome to the board..

Try

=SUMPRODUCT(--(B2:B100="Lease Review"),--(TEXT(C2:C100,"mmyy")="0914"))

 

[Jonmo1]

Glad to help, thanks for the feedback.