Although the criteria range can be located anywhere on the worksheet, do not place the criteria range below the list.

• 虽然条件区域可以在工作表的任意位置,但不要将条件区域置于列表的下方。