google-sheetsimportgoogle-sheets-formulacountingcountif

How to Importrange + Count on Google Sheets?


I'm trying to import data from another worksheet and count it simultaneously. It's only producing 1 for me, rather than 11 - which is what it should be.

I've tried the following:

=COUNT(IMPORTRANGE("URL","Shirts!F:F"))

Solution

  • first you need to run your importrange formula and allow access to link your sheets:

    =IMPORTRANGE("URL", "Shirts!F1")
    

    then try:

    =COUNT(IMPORTRANGE("URL", "Shirts!F:F"))
    

    also make sure your set is numeric