Hi Leo,

Yes, without entering as CTRL-Shift-Enter, was what I intended to write.
:)

I thought it was curious that SUM evaluates an explicit array but not an
implied one. Its also interesting that the function builder returns the
result of the implied array but the final function does not.

I guess as you say that is the design, but I feel that its inconsistent.
Back to SUMPRODUCT I go.

Cheers

Dave


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!