#ExcelTip
Absolute reference is when the reference within a function is locked so that rows and/or columns won’t change if the function is copied
The dollar sign is used to lock the reference and make it an absolute reference. For example, instead of referencing cell H4 in a function, you could make an absolute reference to column H ($H4), to row 4 (H$4) or lock both the column and the row ($H$4)