Hi There,

Would anyone be able to tell me why I am getting a #VALUE! error on the
following function;

=SUMPRODUCT(--('CHANGE ORDER LOG'!$E$7:$N$7="P"),--('CHANGE ORDER
LOG'!$E$7:$N$7<""),--('CHANGE ORDER LOG'!$D$1:$D$10000="*Hours"),--('CHANGE
ORDER LOG'!$D$1:$D$10000<""),('CHANGE ORDER LOG'!$O$1:$O$10000))

Thanks so much
--
CK