Another great tip.
Thanks, again,
RAD

"Rick Rothstein (MVP - VB)" wrote:

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.