Pinterest Pixel

Excel Table: Row Calculations

One of the most powerful feature of an Excel Table is the use of formulas to calculate... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

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.

Excel Table: Row Calculations | MyExcelOnline
download workbookTotal-Row.xlsx

 

STEP 1: Select any cell in your table. Go to Table Tools > Design > Table Style Options > Total Row

Excel Table: Row Calculations

STEP 2: A new row has been added. Select Count for the REGION column

See also  Dynamic Data Validation List

Excel Table: Row Calculations

STEP 3: Select Max for the ORDER DATE column
.
Excel Table: Row Calculations

STEP 4: Select Sum for the SALES column

Excel Table: Row Calculations

Now you have your updated values! They get updated automatically as you add new rows and change values!

Excel Table: Row Calculations

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

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!