I would like to use the COUNTIF and IMPORTRANGE functions in Google Sheets, but the results keep returning 0. Here's my formula:
=COUNTIF(IMPORTRANGE("sheet key","PDFs!A2:A13"), "Yes")
There are no permission restrictions on the sheet I am trying to query, though I might restrict it to specific people.
I've tried the formula using the key and the sheet URL.
I've tested the formula with a tab in the same sheet and it works. Here is the formula I used:
=COUNTIF(PDFs!A2:A13,"Yes")
Any thoughts on why the COUNTIF/IMPORTRANGE formula isn't working?
Would restricting permissions make the formula not work?