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

Consolidate in Excel with the CONSOLIDATE Tool The Consolidate tool in Excel is located in the Data menu and combines values from multiple ranges into one new range. You would use this feature when you have a single text column on the left and the column has many duplicate values. First you need to select a blank cell o...
Show Pivot Table Values As a Running Total In If you want to track your sales on a monthly basis and see their Year to Date totals, then you can easily do this with the Running Totals In calculation. You can activate this by Right Clicking on your Pivot Table values and choosing Show Values As and Running Total In.  You c...
Drop Down List with Data Validation One of the coolest features of Excel is to create a drop down list with your data.  It is one of the first things that I learned and use on a daily basis. You can create a drop down list to eliminate manual entry and re-entry of data, as well as reduce data entry mistakes if y...
Custom Number Formats in Excel A custom number format in Excel can have up to four different sections in the following order: Positive format; Negative format; Zero format; Text format   You can specify different format codes for each section as long as they are separated by a semicolon. So you ca...