CountIFS和ImportRange

Question

我试图在从另一个excel导入数据并在两个不同列的条件下计算数据：

第一个条件：

=COUNTIFS(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1suV8EPH4HtwAEuBX6XpQ3dLsUrFHasgMHFVFJRR4j6M/edit#gid=168725841","Flow!K6:K3000"),B6,IMPORTRANGE("https://docs.google.com/spreadsheets/d/1suV8EPH4HtwAEuBX6XpQ3dLsUrFHasgMHFVFJRR4j6M/edit#gid=168725841","Flow!F6:F3000"),"=Complete")

我想数行数

Flow!K6:K3000 = B6 (a string) and Flow!F6:F3000 "=Complete"

输出总是以0的形式出现。

Answer 1

没有必要在你的公式中加上"=“。你可以试试下面的方法。

=COUNTIFS(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1suV8EPH4HtwAEuBX6XpQ3dLsUrFHasgMHFVFJRR4j6M/edit#gid=168725841"，“Flow！K6:K 3000”)，B6，IMPORTRANGE("https://docs.google.com/spreadsheets/d/1suV8EPH4HtwAEuBX6XpQ3dLsUrFHasgMHFVFJRR4j6M/edit#gid=168725841"，“Flow！F6:F 3000”)，“完整”