count the amount of times a two letters appears in text string

[Sam]

please help!!

I have a column of different sequenced letters.eg
AD
AFD
AC
AFDE
ADEF

I want to count the amount of times that both "A" and "D" occur in the data
set (4).

 

[Teethless mama]

=SUMPRODUCT(--(ISNUMBER(SEARCH("A*D",A1:A5))))

 

[Teethless mama]

=SUMPRODUCT(--(ISNUMBER(SEARCH("A*D",A1:A5))))

 

[Jacob Skaria]

Using COUNTIF() in Col A

=COUNTIF(A:A,"*A*D*")

If this post helps click Yes

 

[Jacob Skaria]

Using COUNTIF() in Col A

=COUNTIF(A:A,"*A*D*")

If this post helps click Yes

 

[T. Valko]

Do you want to count if those 2 letters appear *in any order* ? For
example:

DFA

Should that be counted?

 

[T. Valko]

Do you want to count if those 2 letters appear *in any order* ? For
example:

DFA

Should that be counted?