Search code examples
google-sheetssumcountingcountifimportrange

How can I do two countifs criteria while using importrange?


How can I use two criterias for countifs while using importrange and sum? This one gives me and error.

=SUM(COUNTIFS(IFERROR(IMPORTRANGE("1Oo_s92eD9EnTdqR7Z1T85vOd6sCxyjvZZX1hECJO7Pg/edit#gid=328894125","Furniture Campaign!H:H")),"Legal - CSA CUL*","Furniture Campaign!M:M","Pending QA/Upload"))


Solution

  • it should be either:

    =COUNTIFS(
     IMPORTRANGE("1Oo_s92eD9EnTdqR7Z1T85vOd6sCxyjvZZX1hECJO7Pg", "Furniture Campaign!H:H"), 
     "Legal - CSA CUL*",
     IMPORTRANGE("1Oo_s92eD9EnTdqR7Z1T85vOd6sCxyjvZZX1hECJO7Pg", "Furniture Campaign!M:M"), 
     "Pending QA/Upload")
    

    or:

    =SUM(IFERROR(COUNTIF(
         IMPORTRANGE("1Oo_s92eD9EnTdqR7Z1T85vOd6sCxyjvZZX1hECJO7Pg", "Furniture Campaign!H:H"), 
         "Legal - CSA CUL*")),
         IFERROR(COUNTIF(
         IMPORTRANGE("1Oo_s92eD9EnTdqR7Z1T85vOd6sCxyjvZZX1hECJO7Pg", "Furniture Campaign!M:M"), 
         "Pending QA/Upload")))