You should be able to do this.
You have all your "Yes" values. You can do a window_sum(if [whatever-calc] = "Yes" then 1 else 0 end)
Something like that.
Looks like you are working with sensitive data. Your question would be easier to answer with a sample workbook. Hack up a parallel data source in excel with bogus data that will allow you to upload an example similar to your actual workbook. We can mess with it together if you can't figure it out from what I suggested above.