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?
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)
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)
