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
Bookmarks