How to sum the maximum value of each column in Google Spreadsheets?
<p>I have a Google Spreadsheet of numbers. How do I take the maximum value from each column, and summarize them using only <strong>one</strong> formula? (No temp cells, no scripts.) </p>

<pre><code>1  2  1
0  1  3
0  2  0
</code></pre>

<p>For the table above the result should be 6 (1+2+3, the maximum value of each column). But I'd like a solution that works for much larger tables, too.</p>

<p>As a more general question, I'd like to find out how I could fold 2D ranges into 1D arrays using an arbitrary operator (like <code>MAX</code> and <code>SUM</code> in this case).</p>