Joining Two Criteria with a Logical AND

Other times, you will want to filter records that match one criteria and another criteria. For example, you may want to extract records where the product sold was XYZ and the region was the West region. This is called a logical AND.

To join two criteria by AND, put both criteria on the same row of the criteria range. For example, the criteria range shown in J1:K2 of Figure 11.11 gets the customers who ordered product XYZ in the West region.

Figure 11.11

Place criteria on the same row to join them with an AND.The criteria range in J1:K2 gets customers from the West region who ordered product XYZ.

_Region Product__

West XYZ

0 0

Post a comment