Google Spreadsheet infinte range in both ways
<p>So if I want to add every number in column B below B26 I can use this:</p>

<pre><code>=SUM(B26:B)
</code></pre>

<p>If I want to add every number below B26, C26, D26 I can use this:</p>

<pre><code>=SUM(B26:D)
</code></pre>

<p>But what can I use if I want to add every number below and next to B26? What I mean is something like:</p>

<pre><code>=SUM(B26:infinte)
=SUM(B26:last column containing data)
</code></pre>

<p>What I want is to make my own Spreadsheet which automatically calculates ANOVA. If I copy data with X rows and Y rows starting from B26 it should work no matter how many rows and how many columns it has. Adding up infinite rows is solved by <code>SUM(B26:B)</code> but how do I add all the columns?</p>