Could someone please explain in more detail the usage of above. I have seen this usage in:

=AVERAGE($6:$6) to yield a dynamic average across row 6. This does not seem to work in a Column setup. I am looking for more details, links, etc.

Thank You.
Alan