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

Split First & Last Name Using Text to Columns There are times when you receive a data set of employee full names in one column and you want to separate the full name into first name and surname in separate columns.One way is to use the Power Query method, which is great if you have lots of data that gets added each day, ...
Summarize Data With Dynamic Subtotals What does it do?It returns a Subtotal in a list or databaseFormula breakdown:=SUBTOTAL(function_num, ref1)What it means:=SUBTOTAL(function number 1-11 includes manually-hidden rows & 101-111 excludes them, your list or range of data)***Go to the bottom...
Find Errors with Go to Special Constants Say you have a data set and want to make sure that each column contains what it is supposed to.For example, say you have a column which contains Dates and you want to check that there are no cells which contain Text.You can easily check this by highlighting that column an...
Row Differences If you have two rows that you want to compare, for example, sale amount versus amount paid, you can easily filter the differences between these two columns by going in to the Find & Select > Go To Special > Row Differences.Once the cells have been identified, you ca...