SUMPRODUCT for conditional counting with multiple text criteria

In reporting, it is common to count rows only when several text conditions are true at the same time. SUMPRODUCT is a useful way to handle that kind of multi-criteria count in one formula.

Each condition acts like a TRUE/FALSE test across the data. In this pattern, TRUE behaves like 1 and FALSE behaves like 0. When you multiply those tests together inside SUMPRODUCT, only rows where every condition is TRUE get counted.

The pattern

For example, a count of orders that are East and Completed would look like this:

=SUMPRODUCT((B2:B13="East")*(D2:D13="Completed"))

Each test checks a full column:

• column B for Region
• column D for Status

If you need Priority too, you can add a third test using column C.

Multiplying the tests together works like AND. A row is counted only if it passes every required test.

Your task

1. Review the order table in A1:D13.
2. Look at the summary prompts in A15:A18.
3. In B15:B18, write a SUMPRODUCT formula for each row to count how many orders match the text conditions named in column A.
4. For each summary row, convert the words in the prompt into matching tests against Region, Priority, and/or Status.

Use the order fields that match each prompt. Some rows need three conditions, while others need only two. Your formulas should return counts of matching rows.