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.

Tasks Completed <tbody> </tbody>	Description <tbody> </tbody>	Technician <tbody> </tbody>	Completed <tbody> </tbody>
2	Task1	Ed	Yes
	Task2	Boe	No
	Task3	John	Yes
	No Assignment	Bob

<tbody>
</tbody>

 

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