You could just use a COUNTIFS formula which takes more than 1 type of criteria if you're sure the order quantity will always be 1. If not, then you can use a SUMIFS formula which sums using more than 1 criteria. Attached is an example of the countifs version.
Bookmarks