One of the most significant new features in Excel 2007 is its support for tables. In this section I describe how formulas work with tables.
Figure 15-10 shows a simple table with three columns. I entered the data, and then converted the range to a table by choosing Insert Tables Table. Note that I didn’t define any names, but the table is named Table1 by default.
If you’d like to calculate the total projected and total actual sales, you don’t even need to write a formula. Simply click a button to add a row of summary formulas to the table:
Activate any cell in the table.
Place a check mark next to Table Tools Design Table Style Options Total Row.
Activate a cell in the Total Row and use the drop-down list to select the type of summary formula to use (see Figure 15-11). ...