Thanks but I am not counting anything here, I am returning the value of 0 or 1 based on condition. The expected the results and the formula I am using is already there in the sheet (COLUMN D) which I have already mentioned.. The issue here is I can't drag the formula cause its a spill