Count - Special case

Sir,

I got the correct answer in my excel sheet (Question.xls), But i apply the same equation to my original excel sheet(same format as Question.xls) but there i don't get the correct answer. I use correct formula as you told. please find my original excel sheet and read the commend inserted and yellow marking fields. kindly help me sir.