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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Turn Text To Values With Paste Special Values Many times you would have received data from your IT system which is formatted wrong!  Well a gazillion times if you work in a mid sized firm 🙂When you try and sum the values you get a count rather than a sum, that is because Excel reads the data as text rather than a value....
Unpivot Data Using Excel Power Query Power Query is a free add-in created by Microsoft for Excel 2010 (or later) and you can download and install it for Excel 2010 and 2013:Click to see tutorial on how to install Power Query in Excel 2013Click to see tutorial on how to install Power Query in Excel 2010In...
Show The Percent of Parent Total With Excel Pivot ...  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 PARENT TOTAL calculation.In the example below I show you how to get the Percent of a Product Total i.e The % Sales of each Product ...
Conditionally Formatting A Drop Down List In a previous post I showed you how to Create a Drop Down List in a Table.    We are now going to take this concept one level further and apply some conditional formatting to the drop down data validation list.This is useful if you want to highlight when a job is completed, c...