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 ...
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
