I have the need to create a quantity summary of information from two types of
text

It is as follows: (all columns have a list of information from which a word
can be choosen - no text can be inputted)

(A1) (B1)
happy D
sad A
tired A
Awake D
happy A
etc.

So the summary should read
(c1)=COUNTIF(A1:A5;"happy") - the result would be 2
(d1) "the question" how do ask for the count of c1 and the criteria of D -
The result would be 1
(e1)"the question" how do ask for the count of c1 and the criteria of D -
The result would be 1

Thanks for any help