i have data something similar to shown below


Col1 Col2 Col3
1 1 Yes
2 1
3 2
4 2 Yes
2
3 Yes
3 Yes
4

So first column has only the unique values present in col2. I wanna calculate for each unique value in col1 the combination of that number and a value "Yes" for it. For example for the about data my answer should be something like
1 1
2 1
3 2
4 0

I want to calculate count of col2 for an value of yes for all unique values as mentioned in Col1. And the verson of excel I am using is 2003.

Thanks