Make Dynamic Ranges in Formulas using OFFSET Function
The OFFSET function makes your range of cells dynamic. This video shows how to use the OFFSET function, the most powerful lookup function in Excel such that when you double click a formula, it will move the range to the right (or left) instead of downwards.