I'm trying to get the total value using QUERY function in Google spreadsheet.
By referring to this page, you can now understand the year and month.
= QUERY (E: F, " select E, sum (F) where E is not null group by E order by E desc label E 'Year month', sum (F) 'Total' " , true)
However, the D column value is output to the E column for the year and month.
Can Inarrow this by specifying column D in QUERY?
I tried various things, but I couldn't realize it because an error occurredI changed the
E part as follows ... everything would result in an error year (E)&month (E) +1 year (E) "&" month (E) +1 format (E, 'yyyy/mm') DATE (YEAR (E), MONTH (E), 1)
I tried to find it using a search engine, but I could only find examples for the year and the month.
Answer # 1
I was able to do it by the following method.
Actually I wanted to make it one cell for "Year and Month", but for the time being, the purpose was fulfilled, so ...
= QUERY (D: F, " select year (D), month (D) + 1, sum (F) where D is not null group by year (D), month (D) +1 order by year (D) DESC, month (D) +1 DESC label year (D) 'year', month (D) +1 'month', sum (F) 'sum' ", true)
- google apps script - i want to specify a single cell in a spreadsheet using variables in gas
- google apps script - if you want to delete a row if the same year and month as the year and month entered in the cell
- google apps script - debugging in gas, but not triggering
- google apps script - i want to create a process like countifs function that can dynamically change the search value in gas
- google apps script - get a row in gas and post it to the last row of another sheet
- google apps script - make text easier to see with web scraping
- google apps script - i want to send similar messages to multiple terminals
- google apps script - [gas] how to enable onedit only when a specific cell is edited
- google apps script - please teach how to check stackdriver logging when gas is executed in the web app
- google apps script - function is not executed when form object is passed in googlescriptrun
- google apps script - post userid to spreadsheet at follow event of line messaging api using gas
- google apps script - when using replace () in gas, it is processed destructively even when sandwiching slice ()
- google apps script - when sending the response contents of a google form from a spreadsheet to an email, if you re-edit the form
- google apps script - gas: the acquisition of the last line number displayed in the email notification of the form is duplicated
- google apps script - i want to replace specified strings all at once and output to another sheet
- google apps script - i'd like to be able to automatically notify slack from spsi every day using gas! !
- google apps script - [gas] i want to avoid approval of gas for duplicate spreads
- google apps script - when sending google spreadsheet data by email, the format of date data changes
- google apps script - regarding slack app, googleappsscript, cannot read property 'length' of undefined error
- google apps script - i want to copy a regular expression formula with a backslash to the cell below with a relative reference