Sub TEST()
ARR = Range("K4:S" & Range("K65536").End(3).Row)
BRR = Range("B2:D2")
ReDim CRR(1 To UBound(ARR))
For T = 1 To UBound(ARR)
CRR(T) = 0
For I = 1 To UBound(ARR, 2)
For j = 1 To UBound(BRR, 2)
If ARR(T, I) = BRR(1, j) Then CRR(T) = CRR(T) + 1
Next: Next: Next
Range("J4").Resize(UBound(CRR)) = Application.Transpose(CRR)
End Sub
Sub cout()
Dim i, j, x, k As Integer
Dim arr, arr1
arr = Range("K4:S" & [k1000].End(xlUp).Row)
arr1 = Range("b2:d2")
Columns("j:j").ClearContents
For i = 1 To UBound(arr)
For j = 1 To UBound(arr, 2)
For x = 1 To UBound(arr1, 2)
If arr(i, j) = arr1(1, x) Then k = k + 1
Next
Next
Range("j" & i + 3) = k
k = 0
Next
End Sub