Absolute and Relative References: Make Your Excel Formulas Work!
There are two types of cell references in Excel formulas and functions: relative and absolute. This is important because relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.
It is important to understand the differences between the two types of cell references so that you can make your formulas return the results you intend.
Excel Formulas and Functions Playlist - • Excel Formulas & Functions
Basics of Excel Formulas Video - • Basic Excel Formulas: Add, Subtract, Multi...
Absolute and Relative References Blog Post -