It's an absolute reference. The $ means that when you copy the formula to
another cell, the item after it remains the same.
eg if you copy a formula down one cell and right one cell, $A$1 remains the
same, $A1 becomes $A2, A$1 becomes B$1 and A1 becomes B2.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
