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.
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.