Summing 2 Columns and Storing in a Array to Calculate Max

[luis_marques]

Hi,


I need to sum 2 columns by each row. I would like a formula to store each sum in array form and right calculate the maximum result beetween array elements.


That is the example:

B1 C1

1 2

2 3

1 1

1 1


Array formula = (1+2;2+3;1+1;1+1)


Max = (5)


Thanks in advance.


Luis

 

[Luke M]

Array formula:

=MAX(A2:A5+B2:B5)


Remember to confirm using Ctrl+Shift+Enter, not just Enter.

 

[luis_marques]

Many thanks!! Works well and simple!!

 

[Luke M]

Glad I could help.