Microsoft Office Tutorials and References
In Depth Information
Figure 9-22: This criteria range has two sets of criteria, each of which is in a separate row.
In this example, the filtered table shows the rows that meet either of the following conditions:
• A condo with a square footage of at least 1,800, in the Central area
• A single-family home of any size, priced at $220,000 or less, in any area
This is an example of the type of filtering that you cannot perform by using standard
Specifying computed criteria
Using computed criteria can make filtering even more powerful. Computed criteria filter the table based on one
or more calculations. For example, you can specify computed criteria that display only the rows in which the
List Price (column D) is greater than average.
Notice that this formula uses a reference to cell D9, the first data cell in the List Price column. Also, when you
use computed criteria, the cell above it must not contain a field name. You can leave that cell blank or provide a
descriptive label, such as Above Average. The formula will return a value, but that value is meaningless.
By the way, you can also use a standard filter to display data that's above (or below) average.