I guess nobody else knows either
Well I got around this by creating two similar custom fields for my sales and support departments, which flags them as a sales or support ticket.
This means I could put this in my filter, as well as excluding the resolved and closed status tickets, and can then set it to filter by ALL the rules instead of any (there will always be some tickets in sales or support, just not necessarily the individual sub categories in support).
Bit messy, and is mildly confusing to someone creating a ticket, but as a workaround it... well it works.