arrays - 多个谷歌工作表按日期查询
解决方案
尝试:
=QUERY({Sheet1!A3:B; Sheet2!A3:B};
"select Col1,sum(Col2)
where Col1 is not null
group by Col1
label sum(Col2)''")
我有多张纸。我想通过日期查询从这些工作表中获取数据。
标签: arraysdategoogle-sheetsgoogle-sheets-formulagoogle-sheets-query
尝试:
=QUERY({Sheet1!A3:B; Sheet2!A3:B};
"select Col1,sum(Col2)
where Col1 is not null
group by Col1
label sum(Col2)''")