use the quick analysis button to sum the range

Be sure to finish the formula with a closing parenthesis as in the screenshot above. Drag through that cell range or add it after the opening parenthesis in the formula as A1:A5. Let’s say you want to add the values in the cells A1 through A5.

Step 3: You’ll see the F unction appear in the cell awaiting the values you want to use. Step 2: Select the arrow next to AutoSum in the Editing section of the ribbon on the Home tab. This is the cell where the formula resides and the result of it displays. Step 1: Select the cell where you want to use the function. If you’ve never used functions before, you can start with the basics of sum, average, minimum, maximum, and count. Plus, you’ll lessen the chance of errors from performing calculations manually. But once you start using them, you’ll appreciate how much time they can save you. Learn to love functionsįunctions and formulas can be intimidating. You don’t have to worry about manually adding, subtracting, multiplying, or dividing a group of cells, which is a tedious task and increases the risk of errors. You’ll then see your data update with the calculation performed. Step 4: When the Paste special box appears, choose the calculation you want to perform in the Operation section. Select Paste > Paste special in the Clipboard section of the ribbon on the Home tab.Step 3: Open the Paste special menu one of these ways: Step 2: Select the cells containing the values where you want to perform the calculation.

Use the keyboard shortcut Ctrl + C on Windows or Command + C on Mac.Select Copy in the Clipboard section of the ribbon on the Home tab.Step 1: Copy the cell containing the number you want to use in your calculation one of these ways: This means that you can add, subtract, multiply, or divide every value in a cell range by a specific number with paste special. However, Excel offers several paste special options that let you paste data and perform basic equations at the same time. Perform paste special operationsĬopy and paste are simple actions that most people know how to use. Use one or use them all to make your daily Excel duties a breeze. With this list of useful tips, you can eliminate tedious work, quickly perform operations, reduce errors, and insert graphs or tables with a click. Use quick analysis to add formats, charts, totals, and tables.

Use the quick analysis button to sum the range