Hi DILIPandey,

D10 is Large, but should not be considered. Only cells rows 5 and 9 meet the specified criteria. In these two rows, column B is blank (criteria 1) and column C is populated but does not contain Green or Yellow or column D does not contain Large (Criteria 2). Sorry if I have not explained what I am trying to achieve clearly but thank you for trying to help me.

Kind regards,
Matt