COUNTIFS Brain dead

[MartinL]

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

	Name [D] Starter [E] 1 John Doe Prawn & Crab ****tail 2 Prawn & Crab ****tail <tbody> </tbody>

<tbody>
</tbody>

 

[wideboydixon]

Try it like this:

=COUNTIFS(NAME,"<>",Starter,"Prawn & Crab ****tail")

WBD

 

[MartinL]

Try it like this:

=COUNTIFS(NAME,"<>",Starter,"Prawn & Crab ****tail")

WBD

genius!