And possibly the more important follow-on question, can anyone think of
a SUMPRODUCT formula where there is a different result with array entry
and the array entered result is the less desirable result?

Jerry

Jerry W. Lewis wrote:

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