Hi I'm trying to create a formula that says count the number of rows where the Value in column Dn is not blank and the value in Colum En = "X"
Like this - where x = "Prawn & Crab ****tail"
=COUNTIFS(LEN(NAME),">0",Starter, "Prawn & Crab ****tail")
Expected answer is 1
<tbody>
<tbody>...