Use Google Sheets QUERY or array to sum where date=date

0
votes

I have a spreadsheet with a couple of sheets in it, I want to summarize sales by date. I'm trying to use the query sum function to summarize everything since I wasn't able to do it with array-formula.

but I'm not able to do it with a query as well. I don't want to just copy-paste the sum function from each row to the next I want to just type the date I need in column A and get all the results in the different column.

https://docs.google.com/spreadsheets/d/1Pjdy3Ywa556aZS3k8euJYyd9d-IR7qVsBKFu7luEQwA/edit?usp=sharing

I want the connection between 2 sheets, meetings, and Circulation. now I need it to summarize the results in meetings!j, where meetings!i = Circulation!A. then multiply by Circulation!i where Circulation!A =< Circulation!H

I tried everything spent hours on this search and everything and wasn't able to accomplish anything. would really appreciate some help!

1
google-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-querygs-vlookup
What is the formula that you tried? – Rubén

1 Answers

0
votes

I want the connection between 2 sheets, meetings, and Circulation. now I need it to summarize the results in meetings!j, where meetings!i = Circulation!A

=ARRAYFORMULA(IFERROR(VLOOKUP(TO_TEXT(A2:A), TO_TEXT(QUERY(Meetings!I:J, 
 "select I,sum(J) where I is not null group by I label sum(J)''", 0)), 2, 0)))

0

then multiply by Circulation!i where Circulation!A =< Circulation!H

=ARRAYFORMULA(IF(A2:A<>"", IFERROR(VLOOKUP(TO_TEXT(A2:A), TO_TEXT(QUERY(Meetings!I:J, 
 "select I,sum(J) where I is not null group by I label sum(J)''", 0)), 2, 0))*
 SUM(FILTER(I2:I, A2:A<=H2:H)), ))

0