How do I get the max value from the sum of two columns in excel?

excel, excel-formula

Solution

You can do it with an "array formula" like this

`=MAX(A1:A3+B1:B3)`

confirm with CTRL+SHIFT+ENTER

You can add an INDEX function to make it a "regular" formula, i.e.

`=MAX(INDEX(A1:A3+B1:B3,0))`

or a non-array version for Excel 2010 or later versions

`=AGGREGATE(14,6,A1:A3+B1:B3,1)`

`14` indicates `LARGE` in `AGGREGATE` function - with the 1 at the end meaning the largest

Problem

Given two columns, A and B like so: ``` | A | B ------------- 1 | 6 | 2 2 | 4 | 5 3 | 8 | 2 ``` Can I write an excel formula that will achieve `=MAX(A1+B1,A2+B2,A3+B3)` without having to type every row into the formula?

Original source