CODEWITHSUNDEEP
arraysdategoogle-sheetsgoogle-sheets-formulagoogle-sheets-query
Jancy Abraham
Jancy Abraham

Reputation: 167

Multiple Google sheet Querying by date

I have multiple sheets. I want to get the data from these sheets by a date query.

enter image description here

enter image description here

enter image description here

I want the Result sheet as below enter image description here

Upvotes: 1

Views: 67

Answers (1)

player0
player0

Reputation: 1

try:

=QUERY({Sheet1!A3:B; Sheet2!A3:B}; 
 "select Col1,sum(Col2) 
  where Col1 is not null
  group by Col1 
  label sum(Col2)''")

Upvotes: 2

Related Questions