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
[TABLE="width: 467"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Name [D]
[/TD]
[TD]Starter [E]
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]John Doe
[/TD]
[TD]Prawn & Crab ****tail
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD][/TD]
[TD]Prawn & Crab ****tail
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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!