Couple alternatives....

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

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

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

Regards,

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


"Rick Rothstein (MVP - VB)" wrote in
message ...
By the way, if you think you might be editing the formula in the future
and that you might not remember to use the array-entered keystroke to
commit it, you can use this less efficient normally-entered formula to get
your result instead...

=SUMPRODUCT(MAX(I2:I27+J2:J27))

Rick


"Rick Rothstein (MVP - VB)" wrote in
message ...
This array-entered** formula should replace it...

=MAX(I2:I27+J2:J27)

** Commit the formula by pressing Ctrl+Shift+Enter instead of just
pressing Enter. Doing this will place curly brackets {} around the
formula... do not try to shortcut the process by typing them in
yourself... that will not work. If you ever edit the formula, you must
remember to commit it using Ctrl+Shift+Enter.

Rick


"RAD" wrote in message
...
Is there a more streamlined way to calculate this?
=MAX(SUM(I2,J2),SUM(I3,J3),SUM(I4,J4),SUM(I5,J5),S UM(I6,J6),SUM(I7,J7),SUM(I8,J18),SUM(I9,J9),SUM(I1 0,J10),SUM(I11,J11),SUM(I12,J12),SUM(I13,J13),SUM( I14,J14),SUM(I15,J15),SUM(I16,J16),SUM(I17,J17),SU M(I18,J18),SUM(I19,J19),SUM(I20,J20),SUM(I21,J21), SUM(I22,J22),SUM(I23,J23),SUM(I24,J24),SUM(I25,J25 ),SUM(I26,J26),SUM(I27,J27))
This =MAX(SUM(I2,J2),SUM(I27,27)) only finds the max of I2+J2 and
I27+J27
This =MAX(SUM(I2:J2):SUM(I27:J27)) returns a formula error.