Well, here're my thoughts on that....

To use array formulas in other peoples workbooks without informing them
about what they are and how to use them practically guarantees I'll get
phone calls that could be avoided.

I make sure all of my users know what an array formula is, yet,
they NEVER remember to C+S+E when done editing the formula. So, I
strategically place +N("Ctrl+Shift+Enter") in some of the
formulas as a reminder. That dramatically reduced the number
of "I broke the formula" calls.

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)



"Rick Rothstein (MVP - VB)" wrote in
message ...
Couple alternatives....

Regular formula:
=MAX(INDEX(I2:I27+J2:J27,0))

Good point! Don't know why, but I seem to instinctively reach for the
catch-all SUMPRODUCT function without spending more time thinking about
the already array equipped ones.

or
Array Formula (with built in reminder)
=MAX(I2:I27+J2:J27)+N("Ctrl+Shift+Enter")

Hey! That's a good idea (although if the user is not familiar with the N
function, it might confuse him/her as well).

Rick