COUNTIF specific combination of figures and character

Hello,

I have a range of cells on which I would like to perform a COUNTIF function.

I have specific rows in my table where I list up product numbers.
This is an example of the contents:
cell A1: BTA 3512; BTA 1875; BTA H333
cell B1: BTA 1873

I would like to count the number of occurences of a BTA numer and also of a BTA H number.

This would be the result I look for (in case the countif range is A1:B1):
BTA: 3
BTA H: 1

Count anyone help me out?

I attached a sample file in case it's not clear.

Thank you for looking into this!

Solvax

Try these:

to count the number of "BTA H" =SUMPRODUCT(LEN(A1:B1)-LEN(SUBSTITUTE(A1:B1,"BTA H","")))/5
to count the number of "BTA" =SUMPRODUCT(LEN(A1:B1)-LEN(SUBSTITUTE(A1:B1,"BTA","")))/3-SUMPRODUCT(LEN(A1:B1)-LEN(SUBSTITUTE(A1:B1,"BTA H","")))/5

Thank you everyone, these solutions solved my problem!
Much appreciated