Thank you for your reply.

My apologies I should have been more clear my formula is COLUMN D is what I want which is returning the value of 1 if for ALL of the years (1995-2003) has values in COLUMN C >= 3 for each of the TICKERS (COLUMN A) - if yes then it should return the value of 1 otherwise 0.

I have corrected my original post accordingly.