Help with a Count formula with multiple criteria

[reverett]

Hello,

I am trying to get a count multiple criteria. I have an basic example of my spreadsheet below. I want to know how many adults were present within each zone. How would I count the number of adults have yes in column B and then get a count of the adults who have yes in column b by zone? The zone is in column A.

Zone	Adults Present
1	yes
2	no
2	yes
3	yes
4	yes

<tbody>
</tbody>

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D	E	F	G
1	Zone	Adults Present		1	2	3	4
2	1	yes		2	1	1	2
3	2	no
4	2	yes
5	3	yes
6	4	yes
7	4	yes
8	1	yes
MHT

Cell Formulas
Range	Formula
D2	=COUNTIFS($B:$B,"yes",$A:$A,D1)

 

[reverett]

It worked! Thank you

 

[Fluff]

You're welcome & thanks for the feedback