Hi,

I need to count how many qualified staff (designated with a "Q*" in their qualification code) in column F are rostered on each day. This means that I need to search for a "Q" in their qualification code, and check that they are rostered that day (by checking that their hours for that day are above zero), then return an expected number between 0 and 4. The cells I need to do this formula in are K34, O34, S34, W34, AA34 (Monday to Friday). The "Q" is always at the beginning of the string.

I have tried {=COUNTIF(K8:K33,SEARCH("Q*",$F8:$F33)>0)} but that returns zero, as well as the non-array version.

Got any ideas?