Microsoft Excel – Using Quick Analysis for % of Totals and Cumulative Totals

To calculate % of Totals in Excel, you would normally have to use absolute cell references or name the Total cell. Similarly for cumulative totals, you would have to create the relevant formula. Provided you have Excel 2013 or a later version than that, you can save the effort of using formulas by using the Quick Analysis tool.

Ensure you have a spare column next to the data for the answers to be inserted. You do not need to have created the total.

Select the data to be used.

At the bottom right, you will see the Quick Analysis button. Click on it.

You can do several things with Quick Analysis including Conditional Formatting, creating Charts, creating Tables and creating Sparklines. Today I am concentrating on some of the Totals options.

Click on Totals along the top of the Quick Analysis section. Further buttons will be shown. The first group are for doing calculations across rows. We are looking at columns here so scroll to the right.

To create percentages of the total, click % Total.

To calculate a cumulative total, click Running Total.

Find out more about our Excel training in the London area.

Find out more about our Excel training in Wiltshire, Dorset, Somerset and Hampshire.

Find out more about our online training.

About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 for every time someone says "If only I'd known that." ....
This entry was posted in Excel 365, Microsoft Excel, Microsoft Excel 2013, Microsoft Excel 2016 and tagged , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s