I have data in two columns. I would like the sum of the two columns, using the maximum value for each row.
C1 C2 1 2 4 3 11 10 5 7
The result would be 2+4+11+10+7.
I would prefer if the solution worked in Google Spreadsheets, but if that can't happen Excel would be ok.