How to use Countif to test if a sequence appears within an array ?

[masterinex]

How do I use Countif to test if a sequence appears within an array ?

peter.PNG

As you can see from my screenshot I tried COUNTIF(A28:A31,B28:B30)
to see if the sequence Peter, glen, greg appears within the array A28:A31.

[acerrhod]

try this
=COUNTIF($A$1:$A$4,B1)
copy down

[masterinex]

are you sure about this ?

[hemesh]

Masterinex you can do with your formula also you just need to enter the array formula.That's it and you are done.
=COUNTIF(A1:A4,B1:B3) enter the same with ctrl+shift+enter to make it array formula and just drag

if you want to sum the result of the total count in one cell then just
=Sum(COUNTIF(A1:A4,B1:B3)) and hit ctrl+shift+enter, You will get the total no of entry based on your criteria

if you are satisfied encourage me by clicking SOLVED and if not get in touch.

[hemesh]

for better understanding after entering formula see the formula evaluation in formula bar