Macro to search a range with multiple combined values

Hi All,

I’m back again looking for help in how to set up the following formula code.
I need to count the number of times in col K (K5:K105) any of the following is entered:
"AV", "BT", "RLCCC", "RLCMO", "RLFW", "RLHCC", "RLHMO", "RPCCC", "RPCMO", "RPHCC", "RPHMO", "TA" And matches one of 8 values listed in col AD rows 5 thru 12. I am thinking that part of the code would use a case or array but am not sure on how to set it up. I have the entire code listed if someone can figure out why my code is giving unstable count results.

I had this code listed below but it does not give accurate count seems to give counts from 3 to 6 for one actual entry.

'If value of col K equals "AV", "BT", "RLCCC", "RLCMO", "RLFW", "RLHCC", "RLHMO", "RPCCC", "RPCMO", "RPHCC", "RPHMO", "TA" and
        'L in same row equals AD5 then AE5 is increased by 1
        If Range("L" & Srn) = Range("AD5") Then
            Select Case Target.Value
                Case "AV", "BT", "RLCCC", "RLCMO", "RLFW", "RLHCC", "RLHMO", "RPCCC", "RPCMO", "RPHCC", "RPHMO", "TA"
                    Range("AE5") = Range("AE5") + 1
            End Select
        End If
I have attached the full workbook if anyone can find out why my code is giving inaccurate results. Thank you for all help in advance.
:confused: