#### Overview of this book

Excel is a popular program. Millions of people throughout the world use it on a regular basis. But it’s a safe bet that the vast majority of users have yet to discover some of the amazing things this product can do. 101 Excel 2013 Tips, Tricks, & Timesavers?is packed with information that you need to know in order to confidently and seamlessly master the challenges that come with using Excel! Excel 2013 is excellent, but there's lots to learn to truly excel at Excel! In this latest addition to his popular Mr. Spreadsheet's Bookshelf series, John Walkenbach, aka "Mr. Spreadsheet," shares new and exciting ways to accomplish and master all of your spreadsheet tasks. From taming the Ribbon bar to testing and tables, creating custom functions, and overcoming "impossible" charts, mixing nesting limits, and more,?101 Excel 2013 Tips, Tricks, & Timesavers?will save you time and help you avoid common spreadsheet stumbling blocks.

Tip 75: Using Formulas with a Table

This tip describes some ways to use formulas with a table. The example uses a simple sales summary table with three columns: Month, Projected, and Actual, as shown in Figure 75-1. I entered the data and then converted the range to a table by using the Insert⇒Tables⇒Table command. Note that I didn’t define any names, but the data area of the table is named Table1 by default.

Figure 75-1: A simple table with three columns.

Working with the Total row

If you want to calculate the total projected and total actual sales, you don’t even need to write a formula. Just click a button to add a row of summary formulas to the table:

1. Activate any cell in the table.

2. Select the Table Tools⇒Design⇒Table Style Options⇒Total Row command and check the Total Row check box.

3. Activate a cell in the Total row and select a summary formula from the drop-down list (see Figure 75-2).

...