Hello,

I'm trying to compare 7 columns in two worksheets, containing text, numbers
and dates. I found here a very helpful formula with sumproduct that woked on
my trial spreadsheet, but returns a #value error on the real thing.

The formula is:

=SUMPRODUCT(--(Sheet2!$A$1:$A10=A1),--(Sheet2!$B$1:$B10=B1),--(Sheet2!$C$1:$C10=C1),--(Sheet2!$D$1:$D10=D1),--(Sheet2!$E$1:$E34=E1),--(Sheet2!$F$1:$F10=F1),Sheet2!G$1:$G$10)

Any ideas what I'm doing wrong?

Thanks,
Maya