Sadly, there simply is no feature in Numbers resembling open-ended cell-range references.
The only manageable workaround I observed actually working as intended involved either using entire rows, or marking as headers all of the columns/rows to be ignored.
"Whole rows" tack, example procedure:
- Normalize and rearrange your data to inhabit the entire set of rows in question, rather than starting in column G.
- in your formulas' references to those areas, don't use any column letters. For example,
COUNTA(G3:AA82,">50") use instead
"Headers" approach, example procedure:
- select Table2 column A
- choose 'Add Header Column Before' from the 'Table' menu (may differ between versions?)
- select cells in the new column A, from A3 down to A82
- from the 'Table' menu, choose 'Merge Cells'
- enter a fitting name for that group of rows into A3
- use that name in any formulas needing those rows
All data following the header column/row is referred to by its chosen label. You'll see Numbers offering it in the auto-complete choices as you type it into formulas, and when chosen that area will be highligted.
They're both means to the same end, and behave similarly in practice. With both, you'll see the desired behaviour that when adding additional columns/rows, the new area will be no exception—the formulas with references to whole rows/columns or names from headers will also see any new data.
Again, particular to your described spreadsheet, note that since you're starting your data in column G, you may need to…
• alter your formulas to ignore non-numbers
• alter your formulas to ignore data that doesn't pass some other test
• rearrange your overall layout so the data starts in column B