How do I count Yes / NO drop-down answers from another workbook?

I have a drop down with a "Yes" or "No" option in column H of my source Google Sheet workbook, on a tab called "Answers 2023"

I'm trying to count the number of times "Yes" is selected from that drop down in column H,and pull that number in to a master workbook. The column will have more added to it over time, so I was trying to create the formula to look at the entire column, not just a range of the rows that are already populated.

So far, I've been trying to use this formula, with no luck:

=QUERY(IMPORTRANGE(“url”;”Answers 2023!H:H");"select H Count(H) where H ="Yes"")

I've also tried replacing H with Col8:

=QUERY(IMPORTRANGE(“url”;”Answers 2023!H:H");"select Col8 Count(Col8) where Col8 ="Yes"")

Even using "," in place of ";"

=QUERY(IMPORTRANGE(“url”, ”Answers 2023!H:H"), "select Col8 Count(Col8) where Col8 ="Yes"")

Anyone have any suggestions?

Try the following

=QUERY(IMPORTRANGE("url"; "Answers 2023!H:H");
      "select Col1, count(Col1) where Col1 ='yes' 
       group by Col1 label count(Col1) '' ")

(Do adjust the formula according to your ranges and locale)

Make sure you use correctly your single and double quotes.

This solved my original inquiry

=COUNTIF(IMPORTRANGE("url", "Answers 2023!H:H"), "No")