Countifs syntax fail

[The Grim Discovery]

People

Could someone help me out with my countifs problem.

I'm trying to count where in col AM the string reads 'Dog' that the corresponding cell in columns BA:BB reads 'Yes'. I've fannied around with this for an hour or so and even tried searching old posts. To no avail.

This is my doomed syntax.

=COUNTIFS(AM:AM,"Dog",BA:BB,"Yes")


Someone please give me a nudge in the right direction.
Muchos thankling.

 

[Norie]

Try this.

=COUNTIFS(AM:AM,"Dog",BA:BA,"Yes",BB:BB, "Yes")

 

[The Grim Discovery]

Thanks Norie - worked a treat