One of the most powerful feature of an Excel Table is the use of formulas to calculate its Column contents.  To activate this you need to click in your Table and go to the Table Tools tab in the Ribbon.  From there you simply need to activate the Total Rows check box.

This will add a Totals Row at the bottom of your Table and by clicking in any of the boxes, a list of formulas will appear!  You can use the default formulas like Average, Count, Count Numbers, Max, Min, Sum plus you can click on More Functions which will let you choose any of Excel´s many formulas.  Try it out by downloading the workbook below.

DOWNLOAD WORKBOOK

Total Row

Helpful Resource:

MOTH-excel_expert470x63

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

How To Create A Custom List In Excel   A Custom List in Excel is very handy to fill a range of cells with your own personal list. It could be a list of your team members at work, countries, regions, phone numbers or customers. The main goal of a custom list is to remove repetitive work and manual errors i...
Rank Largest to Smallest With Excel Pivot Tables Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the RANK LARGEST TO SMALLEST calculation. This option will immediately calculate the rankings (1 being the LARGEST value) for your values, allowing you to pi...
Show The Percent of Row Total With Excel Pivot Tab... Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF ROW TOTAL calculation. This option will immediately calculate the percentages for you from a table filled with numbers such as sales data, exp...
Dynamic Data List using Excel Tables Excel Tables have many great features to them and one of them is their ability to create a dynamic drop down list. A dynamic drop down list expands as the Excel Table expands when new data gets added to it. This is great when you want to have users select from a predefined ...