Count if /Count ifs help

[Imran Azam]

Hi Guys

I have the below data , i am trying to do a formula that would count the number of "open" status the Manager "roy" has.

i tried a countifs but could get it right

can any one provide any help?

	A	B	C	D
1	name	manager	id	status
2	james	roy	1	open
3	jack	roy	1	closed
4	alex	Ian	1	open
5	jack	roy	1	open
6	jones	Ian	1	open

<tbody>
</tbody>

Thank you in advance

 

[AlanY]

Book1
	A	B	C	D
1	name	manager	id	status
2	james	roy	1	open
3	jack	roy	1	closed
4	alex	Ian	1	open
5	jack	roy	1	open
6	jones	Ian	1	open
7
8
9	roy	open	2
Sheet4

Cell Formulas
Range	Formula
C9	=COUNTIFS(B2:B6,A9,D2:D6,B9)

 

[Imran Azam]

	A	B	C	D
1	name	manager	id	status
2	james	roy	1	open
3	jack	roy	1	closed
4	alex	Ian	1	open
5	jack	roy	1	open
6	jones	Ian	1	open
7
8
9	roy	open	2

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet4​

Worksheet Formulas Cell Formula C9 =COUNTIFS(B2:B6,A9,D2:D6,B9) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

thank you

 

[AlanY]

you're welcome