 Tweet # Excel For Noobs Tutorial: Formulas and Funtions in the Tables Total Row

## The Total Row in Excel Tables

In this tutorial I will show how formulas and functions refer to cells within an Excel table.

Below you can see that I have created a simple table that shows a list of employees and list each representatives sales for 2011 and 2012. The first thing that I am going to show you is how simple it is to add a Total Row which will greatly simplify using formulas and functions in Excel tables. Step 1: Select any cell within the table and the Table Tools should appear providing you with a new tab in the ribbon that is labeled Design.

Step 2: Click on Design. Step 3: Locate the Table Style Options group and check the Total Row box. Now in the very bottom row of the table a Total Row will appear with a value showing the sum of the very last column in the table, 6904000 in our case. Step 4 Select a cell within the Total Row and you will notice that a box with a downward arrow appears to the right. Click on this downward arrow and you will see a list of common summary functions that are capable of using a range of cells as a function argument.

Now that you have your total row you can use functions without having to manually insert them. Excel simply does all the work for you. If you dont see the function you need then click on the More Functions option and the Insert Function dialog box will appear. Here you can search for the function you need. When you select your function the Function Arguments dialog box will appear. If your function is capable of using a range of cells as an argument then it will automatically be inserted in the Function Arguments dialog box. However, if you use a function that cannot use a range of cell as an argument then you will need to specify your argument as we did in previous tutorial. (Search for Function Arguments to locate this lesson).

## Function Arguments in the Total Row of an Excel Table

Take a look in the formula bar when the total row for 2012 sales is selected. The formula shown in the formula bar is:

=SUBTOTAL(109,[2012 Sales])

In the SUBTOTAL function the first argument, number 109, is a numeric representative of SUM and the second argument, 2012 Sales, represent the 2012 Sales column in our table which is all the values within the 2012 Sales column of our table.

Find the next tutorial in the links below. 