No, and array entry does fix the problem. I second Jay's kudos about a
good catch!

Any idea about what it is doing without array entry that the result
depends on where the formula resides?

Also, has anyone compiled a list of functions that require array entry
inside SUMPRODUCT?


Jerry

Peo Sjoblom wrote:

Did you array enter it? TRANSPOSE even inside SUMPRODUCT always need to
be array entered