Thank you, I was finally able to find some after scrolling all responses a third time.

Pretty good ideas to add to my bag of tricks, thank you OP for another great game

I went right for sumproduct() - that's my go-to formula for multi-conditional problems like this.