I would like a formula to count how many cells contain a code that begin with
B, then with Z and O.

So B's would be 3 Z's 5 and O's 1.

1 BBL
2 BBL
3 BBL
4 ZZ3
5 ZXX
6 ZZ1
7 ZZ1
8 ZZ6
9 ODA