Indicates the comparative location of a cell that contains data selection
Absolute adduction
We can add $ in front of any adduction if we need the adduction unchanged, by this way, we can use an absolute adduction to a cell.
This example contains three kinds of correct absolute adduction. “$C$1:” won't change when we copy it to another cell. The “A” in “$A1:” won't change, but “ 1” will. The “B” in “B$1:” will change but “ 1” won't.