Excel 2008 SUMPRODUCT Filter by Date Question

Hello,

Hoping someone could assist.

Sheet1: Column D4 has dates (10/01/2013. 10/03/2013, etc.)
Sheet 2: Column C15 has a data validation list showing every month in a year.
Sheet 2: Column C19 has the sumproduct formula. All the data is being pulled from Sheet1 in this formula.

How can I adjust this formula:
=SUMPRODUCT((Position_Applied_For = $B19)*(Language = $C$14)*1)

...so that based on the selection in the validation list it only pulls data for the month of October in sheet 1?

Who is Participating?

I created a dynamic named range Application_Date referring to column D, then used this formula:
=SUMPRODUCT((Position_Applied_For = $C9)*(Language = $D$4)*(TEXT(Application_Date,"mmmm")=$D$5))EE-SampleQ28257490.xlsx

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

You could also use the MONTH function for a shorter formula. It will be slower, however, because the formula needs to calculate the month for each cell in the date range.
=SUMPRODUCT((Position_Applied_For = $B19)*(Language = $C$14)*(TEXT(Sheet1!$D$2:$D$1000,"mmmm")=$C$15))

If these formulas are not working for you, please post a sample workbook that demonstrates the problem.

This type of problem can also be solved using a PivotTable. The advantage of PivotTables is that no formulas are required. I've set one up for you on Sheet2 in the attached workbook.EE-SampleQ28257490.xlsx