We lock the mobile reference within the formula, so Google Sheets knows not to transfer the reference if the formula is moved. I am able to highly propose the “Advanced Formulas 30 Day Problem”, it has a wealth of useful bits of info and all with short simple to understand https://connerulylv.bloguerosa.com/34505092/bill-template-free-for-dummies