Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
I'm trying to eliminate (not hide) the column headings from the following QUERY(). The output from the =QUERY() must be in a single row.
=QUERY(myData!A:G, "Select SUM(E), SUM(F) WHERE D ='"&E11&"'")
The current output is shown in images #1 and #2 below. The desired output is shown in image #3. Thanks for any help you can offer.
Image #1
Image #2
Image #3
To remove headers, you should refer to the data range A2:G rather than the full columns A:G, and explicitly set the headers parameter to zero.
Additionally, you need to use the label clause to omit automatic headers in any aggregated columns, like this:
=query(
myData!A$2:G,
"select sum(E), sum(F)
where D = '" & E11 & "'
label sum(E) '', sum(F) '' ",
0
)
headers is missing, query() tries to guess the number of header rows, and may guess incorrectly. If it guesses incorrectly, values will be missing from the sum, or superfluous values will get included (in the event the headers contain numbers.) Ditto for a data range that includes rows that are not data but headers. Additionally, when headers is missing, and the column is mostly blank, query() may set the column type incorrectly. I see no reason to ignore these scenarios as that amounts to trying your luck.
Jun 11, 2022 at 20:07
try this one:
=QUERY(myData!A:G, "Select SUM(E), SUM(F) WHERE D ='"&E11&"'label SUM(E) '', SUM(F) ''")
