The cell reference D$17 is an example of an "anchored or an absolute reference." It means that the row or cell or column is anchored. When you try to copy excel formulas, it will copy the cells referred in that formula relative to the position where they are being copied to.
