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?