Countifs formula with multiple criteria against a single range

hi there, long time lurker, first time poster.

I'm trying to use a countifs formula - I'm fairly proficient in these but this time i've got a curve ball and struggling to get past it.

In one of the range, criteria arguments I want to count on multiple criteria within the same range. I've tried a few different attempts with things i've found on the web but to no avail.

my current formula looks like this. I'm trying to find a better way rather than creating a huge replicating formula for the 3 criteria, and i've tried to build an array into multi-criteria part.

=COUNTIFS(WAIT_Data[report month],h$3,Wait_Data[CCCLCC],{"485abc","485def","485ghi"})

regardless of whether i CTRL+SHIFT+ENTER for the array formula it only returns the countif based on the first of the three criteria.

any suggestions for how to get around this?


(the above is an insert of the full formula, there are actually 6 range/criteria combinations but all but the last one is calculating fine)

Cheers,
GH

=sumproduct(countifs...

Try:

=SUM(COUNTIFS(WAIT_Data[report month],h$3,Wait_Data[CCCLCC],{"485abc","485def","485ghi"}))