- Introduction
- Understanding Formulas
- Creating a Simple Formula
- Creating a Formula Using Formula AutoComplete
- Editing a Formula
- Understanding Cell Referencing
- Using Absolute Cell References
- Using Mixed Cell References
- Using 3-D Cell References
- Naming Cells and Ranges
- Entering Named Cells and Ranges
- Managing Names
- Simplifying a Formula with Ranges
- Displaying Calculations with the Status Bar
- Calculating Totals with AutoSum
- Calculating Totals with Quick Analysis
- Performing One Time Calculations
- Converting Formulas and Values
- Correcting Calculation Errors
- Correcting Formulas
- Auditing a Worksheet
- Locating Circular References
- Performing Calculations Using Functions
- Creating Functions
- Creating Functions Using the Library
- Calculating Multiple Results
- Using Nested Functions
- Using Constants and Functions in Names
Calculating Totals with Quick Analysis
When you select a range of cells, you can use the Quick Analysis tool (New
!
) to calculate totals for the data. The tool allows you to calculate totals for Sum, Average, Count, % Total, and Running Total. The result of the totals can appear below the selected range or to the right of the selected range. You can point to a button option to display a live preview of the results before you commit to it. In addition to calculating totals, you can also use the Quick Analysis tool (New
!
) to format data and create charts and tables.
Calculate Totals with Quick Analysis Below Selection
Select the range of cells you want to total.
A Quick Analysis button appears in the lower right corner of the selection.
Click the Quick Analysis button.
A menu appears, displaying heading tabs along the top, and buttons below it.
Click Totals.
To preview the totals result, point to the button (select an icon with blue row) with the type of total calculation you want.
- Scroll Arrows. Click a left or right scroll arrow to display buttons.
To set the totals results result, click the button (select an icon with blue row) with the type of total calculation you want.
Calculate Totals with Quick Analysis Next to Selection
Select the range of cells you want to total; make sure the column to the right is available to place the results.
A Quick Analysis button appears in the lower right corner of the selection.
Click the Quick Analysis button.
A menu appears, displaying heading tabs along the top, and buttons below it.
Click Totals.
To preview the totals result, point to the button (select an icon with gold column) with the type of total calculation you want.
- Scroll Arrows. Click a left or right scroll arrow to display buttons.
To set the totals results result, click the button (select an icon with gold column) with the type of total calculation you want.