Administration and Executive AssistantTier 435 minintermediate

FILTER for Multi-Condition Counts and Totals

Count and total rows that match two conditions at once, the array-formula way.

What you will learn

• Combine two conditions inside FILTER with multiplication, the same AND logic as SUMIFS/COUNTIFS
• Wrap FILTER in ROWS() to count matches or SUM() to total them
• Compare a FILTER-based answer against a single-condition COUNTIF/SUMIF to see what the second condition catches

Excel skills

FILTER, ROWS, SUM · Dynamic Arrays

The task

I need to know how many orders were actually delivered in KwaZulu-Natal this period, and what they added up to. Cancelled orders should not be in that count, even if they were placed in KwaZulu-Natal.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free