# Working with Formulas and Functions in Excel 2013

• Print
This chapter is from the book

## 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.