#VALUE! error

[Anthony]

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

 

[Mangesh Yadav]

Try the following:
Select the cell containing the formula and then
Tools > Formula Auditing > Evaluate formula.
It will show you step-by-step calculation, and you will know who is the
culprit.
Are the names DateofLog and crew well-defined.

Mangesh

 

[Bob Phillips]

Is the DateLog range and the crew range the same size, SUMPRODUCT needs
this.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)