Hi the use of $ is to change a formula absolute to relatvie, you could use it
in a Column as =AVERAGE($A:$A) or in specific range or unique cell

hth
regards from Brazil
Marcelo

"awy32" escreveu:


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