Counting Names based on a condition

Please help.

I am unable to count the number of times a string occurs in a range based on a condition. The constraint which I have is as below.


Count the number of times "Passed to Training" occurs in column1 only if the corresponding field in column two is "Not Started"

I have uploaded the file which I used. Please provide your valuable suggestions to achieve the requirement

If you're using Excel 2003 then something like this:

=SUMPRODUCT(--(Phase1="Passed to Training"),--(Phase2="Not Started"))

If you're using Excel 2007 or later then you can use a COUNTIFS:

=COUNTIFS(Phase1,"Passed to Training",Phase2,"Not Started")