Criteria Range

A block of cells whose top row copies the exact column headers from the data, with the conditions written underneath. Conditions on the same row are ANDed and conditions on different rows are ORed; a blank cell means no condition on that column.

When to use

It drives the Advanced Filter and the Database Functions (DSUM, DAVERAGE, DCOUNT). Headers must match the data exactly, and a blank row in the range matches every record, so select only rows that contain conditions.

See Lec 01.

Appears in

No references yet.