In Google Sheets how to reference infinite rows in column?

Question

If I want to reference a span of rows I can do something like A1:A100. If I want to lock the column/row I can use $; $A1:$A100.

Is there notation or a symbol that represents an infinite range, or every row that could possibly be in a column?

Something like $A! or whatever?

Answer 1

To reference an entire column you can use, for example:

 Sum(A:A)

So I guess the syntax you are looking for is A:A

Equally, if you want to use every piece of data in a column excluding the first, lets say 2, rows you can use A3:A (in google sheets only)

Answer 2

Google sheets is more flexible, you can use the syntax

=Sum(A2:A)

or even

=Sum(A2:C)

You can also do the same with rows e.g.

=Sum(B2:2)