So Absolute Referencing gives you the ability to lock down certain parts of a calculation or formula. So if you have a cell reference in your formula that needs to stay fixed (that shouldn’t move with the formula), slapping the dollar signs on them stops them moving!
The video below covers this off nicely, with examples thrown in and even a ‘Happy Accident’ to quote Bob Ross!
As always though, if there’s something nagging you that didn’t quite make sense, please feel free to get in touch with us and we’ll help you as best we can!
Dave The Spreadsheet Guy 