Microsoft® Office Excel® 2007 Plain & Simple

Creating a Formula that References Values in a Table

In previous versions of Excel, it was a challenge to create named ranges that included an entire column in a data list. Suppose that you created a named range that encompassed the existing cells in a data column, such as the cell range A3: A44; if you added data to cell A45, you would need to change the cells in the named range’s definition. Yes, there is a complicated way to create a dynamic named range in Excel 2003 and earlier versions, but you don’t have to worry about it in Excel 2007. All you need to do is create a data table (as shown in "Creating a Data Table") and select the headers of the columns that contain the data you want to summarize in your formulas.

Create a Formula with ...