Count how many times a text group appears in a range

[Osvaldo Palmeiro]

Please, I would like to have a formula to calculate how many times the group of words in D1: D3 appears, in that order, in the range A1: A20.
The formula should return 4.
Thanks in advance.

A			D
cat			cat
dog			dog
turtle			turtle
aaa
kkk
cat
dog
turtle
xxx
cat
dog
turtle
cat
dog
turtle
aaa
dog
cat
xxx
turtle

<tbody>
</tbody>

 

[Logit]

	A​	B​	C​	D​	E​	F​	G​
1​	cat			cat	5	=COUNTIF(A1:A20,D1)
2​	dog			dog	5	=COUNTIF(A2:A21,D2)
3​	turtle			turtle	5	=COUNTIF(A3:A22,D3)
4​	aaa
5​	kkk
6​	cat
7​	dog
8​	turtle
9​	xxx
10​	cat
11​	dog
12​	turtle
13​	cat
14​	dog
15​	turtle
16​	aaa
17​	dog
18​	cat
19​	xxx
20​	turtle

 

[steve the fish]

This should do it:

=COUNTIFS(A1:A20,D1,A2:A21,D2,A3:A22,D3)

 

[Osvaldo Palmeiro]

Hi, Logit. Thanks for reply, but I was hopping to a count for the group of texts located in D1: D3, and not individual counting for each text separately.

Hi, Steve. Thanks for the solution. It worked as expected.
As I've posted just a reduced sample, so the range in A could be A1: A150 and the searched range could be D1: D10, for example, would there be some other formula, maybe an array one, that could reference the ranges directly? Something like SUMPRODUCT (A1: A150, D1: D10).
Thanks any way.