This tells Excel to add all the numbers from cells A2 to A6 in ... Now that you understand how formulas work, you can start using them in your spreadsheet to automate repetitive calculations ...