Counting on the Yes and not the No, pivot table question

[sunshne900]

Hi everyone,
I have a table and I want it to count only the yes, and not the no, how do I do that?


Thank you for the help.

 

[etaf]

what I have done in the past is to create a new column in the table
If( Cell = "yes", 1, 0)


and then used that column and used sum


or you should be able to count and then use filter the for yes

Excel Workbook
	A	B
1	Question	Answer
2	1	yes
3	2	no
4	3	no
5	4	no
6	5	yes
7	6	yes
8	7	yes
9	8	yes
10	9	no
11	10	no
12	11	no
Sheet1

Excel Workbook
	A	B
1
2	Answer	yes
3
4	Row Labels	Count of Answer
5	1	1
6	5	1
7	6	1
8	7	1
9	8	1
10	Grand Total	5
11
Sheet4