The $ symbol means absolute cell reference. So when you copy the formula some
where else it will always refer back to that Column, Row or Cell. Ex. $A1,
A$1 or $A$1.

"function" wrote:

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?