Can't add criteria to SUM(COUNTIF(INDIRECT

[Ochimus]

Apologies if this has been covered before, but I can't find anything on the net?

Formula in AU3 and AV3 on the attached sets a "fixed " range of non-contiguous columns to calculate how many night shifts and how many early/afternoon shifts match a string over two weeks.

=SUM(COUNTIF(INDIRECT({"E4:K15","Q4:W15","AC4:AG15","AL4:AN15"}),"*SHELLS*"))

I want to add two criteria to the formula, so it finds only the records where the Trading Period in COl D matches AS4 and AS5, and the Weeks in Col C match AT4 and AT5

Col AX:BB show what the criteria should produce.

Any solutions, suggestions or alternative welcome as ever.

Ochimus