OK, if you can give us 5 values for the 5 arguments and tell us what result
you expect
we might be able to figure out what the problem is.

RBS


"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.