valid formula doesn't work in 2003 version
 

=SUMPRODUCT(--(AU8:AU55-DAY(AU8:AU55)+1=AZ57),AX8:AX55) This formula works
well in my version (2002 SP1) but when I try to use my workbook at the
office, (version 2003) the formula gives me #value as a result. I've tried to
format my dates differently but no luck. Can anyone help me resolve this
problem? Thanks

--
D. W. Cameron

valid formula doesn't work in 2003 version
 

Try this, copy an empty cell, select all number involved in the formula,
then do editpaste special and select add

--
Regards,

Peo Sjoblom

(No private emails please)


"Wayne Cameron" wrote in message
...
=SUMPRODUCT(--(AU8:AU55-DAY(AU8:AU55)+1=AZ57),AX8:AX55) This formula works
well in my version (2002 SP1) but when I try to use my workbook at the
office, (version 2003) the formula gives me #value as a result. I've tried
to
format my dates differently but no luck. Can anyone help me resolve this
problem? Thanks

--
D. W. Cameron