Count instances if Yes is indicated

[gimage]

I'm trying to count how many times a part of a word appears if a Yes condition appears in an adjacent column.
The "2" is how many times "Yes" appears when the word "Task" appears also.
Thanks for any help with this.
Greg.
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 109"]
<tbody>[TR]
[TD="class: xl126, width: 109"]Tasks Completed[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 72"]
<tbody>[TR]
[TD="class: xl126, width: 72"]Description[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 69"]
<tbody>[TR]
[TD="class: xl126, width: 69"]Technician[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 69"]
<tbody>[TR]
[TD="class: xl126, width: 69"]Completed[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Task1[/TD]
[TD]Ed[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Task2[/TD]
[TD]Boe[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Task3[/TD]
[TD]John[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]No Assignment[/TD]
[TD]Bob[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

Looks like...

=COUNTIFS(B:B,"Task*",D:D,"Yes")

 

[gimage]

Works perfectly. Thank you.

 

[Aladin Akyurek]

Works perfectly. Thank you.

You are welcome.