4
1
I have data in two columns. I would like the sum of the two columns, using the maximum value for each row.
For instance
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.
Looks good. If no one posts a one-cell answer I'll accept. – Chris Marasti-Georg – 2012-01-01T17:22:20.797