How to use the countif funtion to count a codes that contain cells with muliple codes.

welcome to the forum. so it's supposed to return 2? try:
=COUNTIF(A:A,"*~~33~~*")

when you use tilde (~), it take the next symbol literally. that means if A1:A2 contains:
*A
BA

and i want to count those *A, i cannot use:
=COUNTIF(A:A,"*A")
that will be anything before "A".

i must use it with a tilde to take the asterisk literally.
=COUNTIF(A:A,"~*A")

if it's possible 1 single cell contains 2 "~33~", and you want it as 2 counts, then:
=SUMPRODUCT(--(LEN(A1:A10)-LEN(SUBSTITUTE(A1:A10,"~33~",""))))/LEN("~33~")

the last portion can of course be divided by 4 instead of LEN("~33~"). just in case you need it for other characters