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.

[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]Zone[/TD]
[TD]Adults Present[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]no[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]yes[/TD]
[/TR]
</tbody>[/TABLE]

 

[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