Google Spreadsheet infinte range in both ways

Question

So if I want to add every number in column B below B26 I can use this:

=SUM(B26:B)

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

=SUM(B26:D)

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

=SUM(B26:infinte)
=SUM(B26:last column containing data)

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 SUM(B26:B) but how do I add all the columns?

Answer 1

To get the whole column from that point and the whole row form that point you can do it like this

SUM(B26:B, C26:26)

To get the whole area below and right next to it you can do the following

=ArrayFormula(SUM(OFFSET(B26,,, MAX(ROW(B26:B)), MAX(COLUMN(B26:26)))))