Conditional Count Formula?

I must admit your question was so long that I couldn't be bothered to read it all but from your explanation at the beginning I wondered whether you are trying to make it all too complicated where a simple COUNTIF function would do.