Click a left or right scroll arrow to display buttons.

To preview the totals result, point to the button (select an icon with blue row) with the type of total calculation you want.

Select the range of cells you want to total.Ī Quick Analysis button appears in the lower right corner of the selection.Ī menu appears, displaying heading tabs along the top, and buttons below it.

Calculate Totals with Quick Analysis Below Selection In addition to calculating totals, you can also use the Quick Analysis tool ( New !) to format data and create charts and tables. You can point to a button option to display a live preview of the results before you commit to it. The result of the totals can appear below the selected range or to the right of the selected range. The tool allows you to calculate totals for Sum, Average, Count, % Total, and Running Total. When you select a range of cells, you can use the Quick Analysis tool ( New !) to calculate totals for the data.

Learn More Buy Calculating Totals with Quick Analysis Microsoft Excel Step by Step (Office 2021 and Microsoft 365)

Quick analysis button in excel