Along with Gord's explanation you might want to see what the F4 key will do.
Type =A1, then before hitting Enter, hit the F4 key four times and notice
the reference changes.

HTH
Regards,
Howard


"awy32" wrote in message
...

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


--
awy32