SUMPRODUCT and dates

[forgetso]

Hi,

I have the following formula:

=SUMPRODUCT(--(A1=sheet!$B$2:$B$5697),--(sheet!$E$2:$E$5697))

In A1 is 20060102 and in the range B2:B5697 are dates formatted in the same way as general.

So essentially what I am trying to match are numbers and then summing the values in E2:E5697.

However, I get returned a #VALUE! error. I have tried making a different column in sheet! with dates constructed from the values in B2:B5697 but this also returns this error.

Does anyone have any ideas why this might be? I have successfully used sumproduct with dates before without any problems.

 

[forgetso]

Update:

there were some non numerical values in the column E.

sorted.

 

[PCL]

For me it's worrking correctly with data in sheet named Sheet