I have spent hours experimenting and can not figure this out. My formula is:

=SUMPRODUCT(('Variance data'!$D$1:$D$65000=$A7)*('Variance data'!$F$1:$F$65000>$B$2)*('Variance data'!$E$1:$E$65000))

Column Variance Data D contains an employee number, so I'm checking to match the employee number in A7, this evaluates to 1 if true and is working fine.

Column Variance Data E contains a dollar figure, and these are being summed when the empoyee number matches, all is good.

The problem is with column Variance Data F. This column contains a date, some in 2004 and others in 2005. I only want to add the values when this date is greater then 12/31/2004 (the value of cell B2. For some reason, the answer is always equal to values for all rows where employee number matches, regardless of date.

Any help?