Excel count formula

Copper Contributor

HI,

 

Can someone help me to arrive the count formula for the below. Need to arrive the count based on the branch where the status is "Yes".  For Eg: Accounts = 4.

 

BranchCountryStatus
AccountsIndiaYes
FinanceUKYes
EngineeringUSAYes
AccountsChinaYes
AccountsFranceYes
EngineeringSpain 
AccountsItalyYes
FinancePoland 
2 Replies
=COUNTIFS(Criteria_range1 = Branch column, Criteria1 = Accounting, Criteria_range2 =Status column, Criteria2 = "Yes")

@Siso90  it is working fine, thank you very much for your immediate support.