Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Statistical Functions

 

=COUNTIFS(B2

Input the formula: =COUNTIFS(B2:B5,"=Yes",C2:C5,"=Yes"). Press Enter to get the result.