Named ranges act like variables, resulting in cleaner formulas like SUM(Payments). Use named ranges for maintainability; change the name once to update all formulas that use it. Its easy to create ...