So that the cell references (row and/or column) will not change during
copying.
Check out this link:
http://www.cpearson.com/excel/relative.htm
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"function" wrote in message
...
I can't remember why you would put a $ in a function in a spreadsheet. I
removed the $ and it didn't change the number that was there, so why is it
needed?