What does the $ mean in "=B$6" for example
 

I know that it is referencing cell B6, but I don't know what the $ is for.

What does the $ mean in "=B$6" for example
 

$ indicates an absolute reference so in this case the row remains as 6 if you
copy/drag the formula into other cells but column would change.

$B6 would keep the column B constant, row will change.

$B$6 would keep both fixed

B6 is total relative so both column and row change.

HTH

"Carmon" wrote:

I know that it is referencing cell B6, but I don't know what the $ is for.