Hi,
I have the #VALUE! error which I can't seem to work out why.

the formula in the cell is

=SUMPRODUCT(--(DateofLog=($U16)),--(crew="Y"))

and I have checked with the Tools-Auditing-Trace Precedents and the cells
and/or columns that they point to are the correct ones. Strange thing is
(well to me anyway) is that I have the exact same formula in another copy of
my workbook and that also points to the same cells and/or columns and works
fine!

I don't understand why this is showing the #VALUE! error

Anybody offer any help

Thanks in advance, oh and Merry Christmas