Find and sum max of row values in two columns

[toss1029783]

I am trying to sum together the maximum values of every row in two columnsusing a single formula.

Example:
<table width="128" border="0" cellpadding="0" cellspacing="0"><tbody><tr style="height:15.0pt" height="20"><td class="xl67" style="height:15.0pt;width:48pt" width="64" align="center" height="20">A</td> <td class="xl66" style="width:48pt" width="64" align="center">B</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt" align="center" height="20">1</td> <td class="xl65" align="center">4</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt" align="center" height="20">2</td> <td class="xl65" align="center">3</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt" align="center" height="20">3</td> <td class="xl65" align="center">2</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt" align="center" height="20">4</td> <td class="xl65" align="center">1</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt" align="center" height="20">5</td> <td class="xl65" align="center">0</td> </tr> </tbody></table>
There are two columns A and B each containing 5 rows of numbers. I want a single formula that sums together the largest number in each row. In this example, the answer would be 4 + 3 + 3 + 4 + 5 = 19.

I have many many rows of data, so a simple =SUM(MAX(A1:B1),MAX(A2:B2),...etc...) solution is not possible.

Thank you for your assistance.

 

[gehusi]

{=SUM(IF(A2:A6>B2:B6,A2:A6,B2:B6))}

Entered via CTRL+SHIFT+ENTER

 

[Haseeb Avarakkan]

Hello, Try,

=SUMPRODUCT(SUBTOTAL(4,OFFSET(A1:B1,ROW(A1:A5)-ROW(A1),)))

 

[toss1029783]

Wow, two very different solutions to the same problem. Both worked perfectly. Thank you very much.