Skip to content


Image: Snippet from Help Article - IMPORTRANGE Imports a range of cells from a specified spreadsheet.

Google Sheets CountIf and ImportRange Return 0 and Won’t Offer to Allow Access

When making references to a range from one Google Sheets into another Google Sheets, you will need the Google Sheets IMPORTRANGE function. If you need to count the occurrences of a certain string of characters or any cell content that meet certain criteria, you may need the Google Sheets COUNTIF function. Combining the two formulas gives you the superpower of counting over an external range based on a criterion. However, there is a catch!