MAX-function of sum of two columns

[Jaymond Flurrie]

1	2
2	1
3	1
1	3
1	1
1	1
5	1
1	2

Trying to find the sum of the max row. That is the values are 1+2=3, 2+1=3, 4, 4, 2, 2, 6 and 3 and the result is then 6.

I think I need an array formula. I tried like: {=MAX(SUM(A1:A8;B1:B8))}
but that's not correct.

 

[Scott R]

=MAX( BYROW( A1:B8, LAMBDA(r, SUM( r ))))

 

[hagia_sofia]

Or simply:

=MAX(A1:A8+B1:B8)

 

[Jaymond Flurrie]

=MAX( BYROW( A1:B8, LAMBDA(r, SUM( r ))))

That works, thanks

 

[Jaymond Flurrie]

Or simply:

=MAX(A1:A8+B1:B8)

That's simpler, a very good solution.

 

[Dave Patton]

T202502a.xlsm
	A	B	C	D
1	1	2
2	2	1		6
3	3	1
4	1	3
5	1	1
6	1	1
7	5	1
8	1	2
2c

Cell Formulas
Range	Formula
D2	D2	=MAX(BYROW(A1:B8,SUM))