When referring to a cell or data range within another, you have 3 referencing methods:
Relative Reference - Use when you want the reference to change depending on where it is used. For example, when using functions across multiple cells, it is best to use a relative reference. Relative references are presented as column letter and row number (A3 or A3:A5)
Absolute Reference - Use when you don't want a reference to change depending on where it is used. For example, if you want a reference to stay the same despite changing the location of the reference, it is best to use an absolute reference. Absolute references are presented with dollar signs in front of and between the column letter and row number ($A$3 or $A$3: $A$5)
Mixed Reference - Use when you want either the column or row to stay the same despite the reference's location. Mixed references are presented with a dollar sign in front of or between the column letter and row number (A$3 OR $A3: $A5)
