That is when sumproduct is used in an array formula mode.

--
Regards,
Tom Ogilvy

"Floyd" wrote in message
oups.com...
Thanks so much for the assistance and certainly the tips on how to
Debug.

I pasted the code in and ran it. I am still getting the same error
message, #VALUE!, but at least it is compiling.

I noticed in another post today that the Mr. Ogilvy recommended using
EVALUATE for SUMPRODUCT. I too tried this with no success.

Cheers.