Assuming your lists of strings are in 1 cell per row - you can use an array formula.

We'll say List A is in `A1:A3`

and Range B is in `B1:B3`

. To count for each one in list A you can use -

```
=COUNT(IF(FIND(A1,$B$1:$B$3)>0,1,0))
```

But this is an array formula, so when you type it you finish by hitting `Ctrl`+`Shft`+`Entr` and you'll see curly brackets `{}`

.

If Range B is in multiple cells you can just use something like -

```
=COUNTIF($B$6:$D$8,A1)
```

There may be another way with formulas, but I can't think of it. You can create a helper column for what you're trying to find using

```
=IF(ISERROR(MATCH($A$1,$B6:$D6)),0,1)
```

Drag it down the rows, then sum that column. But that's a lot of helper columns if you want to count it for each value..

If you're open to VBA, a UDF similar to this would work -

```
Public Function countrow(rng As Range, str As String) As Integer
Dim a As Integer
a = 0
For Each Row In rng
For Each c In Row
If InStr(1, str, c) Then
a = a + 1
Exit For
End If
Next
Next
countrow = a
End Function
```

like -

```
=countrow(A6:C9,A1)
```