count the number in if condition is met

[chriskhan90]

I have this table where I would like to count the number if condition are meet

condition:
if it is HR and 1 then count, others will ignore till the end of table

end result:
2

may I know which formula to use, I'm not very familiar with excel formula
thanks

dept	status
hr	1
it	1
hr	0
fi	0
hr	1

[oeldere]

I should solve this with a pivot table.


Rijlabels Som van status
fi 0
0 0
hr 2
0 0
1 2
it 1
1 1
Eindtotaal 3

[JohnTopley]

Dept in Column A, Status in Column B

=COUNTIFS(A2:A6,"hr",B2:B6,1)