One problem that comes up a lot in Excel is counting or summing based on multiple OR conditions.

This can be surprisingly tricky, so naturally it makes a good challenge!

The challenge

The data below represents orders, one order per row.

What formulas will show correct counts based on multiple OR criteria?

There are three separate challenges.

The result is a single column array each time MATCH is used.

SUMPRODUCT then sums the array and returns the result.

What formulas will show correct counts based on multiple OR criteria?

What formulas will show correct counts based on multiple OR criteria?

What formulas will show correct counts based on multiple OR criteria?

What formulas will show correct counts based on multiple OR criteria?