extract total based on resaults

[Rami9]

I have 2 sheets, “Brief” contains Course Title, and the other sheet “Dbase” contains Students names, Course Title and Status “Succeed or Failed”

I want to put the total number of succeeded students in each course in sheet “Brief, column B, as explained in the attached file.

Thanks

 

[bosco_yip]

In "Sheet Brief" B2, formula copy down :

=COUNTIFS(Dbase!B$1:B$100,A2,Dbase!C$1:C$100,"Passed")

Regards

 

[Rami9]

many thanks, it worked perfectly.