Skip to main content
Web Applications

Return to Question

Tweeted twitter.com/StackWebApps/status/1193045705859981314
edited tags
Link
Rubén - Volunteer Moderator - ♦
Rubén - Volunteer Moderator - ♦
  • 46.1k
  • 18
  • 100
  • 297
Wear a tight-fitting neck
Source Link
Eight Days of Malaise
Eight Days of Malaise
  • 16.2k
  • 6
  • 60
  • 89

How can I avoid the Remove header and blank row from the results of thisa SUM, GROUP BY query?

I have a two column table where the one column is some sort of key where duplicates are allowed and the other column is some sort of amountincludes amounts. I

I then have the following formula somewhere else on the sheet:

=QUERY(A1:B, "SELECT SUM(A) GROUP BY B")

The results of that query begin with 'sum', then a blank line, then the summed values. See screenshot:

enter image description herespreadsheet with sum

How can I modify the existing formula so that I do not have the 'sum' header and the blank line (if I can at all)? I want to avoid using multiple cells to create the desired affect and I want to avoid scripting.

How can I avoid the header and blank row from the results of this query?

I have a two column table where the one column is some sort of key where duplicates are allowed and the other column is some sort of amount. I then have the following formula somewhere else on the sheet:

=QUERY(A1:B, "SELECT SUM(A) GROUP BY B")

The results of that query begin with 'sum', then a blank line, then the summed values. See screenshot:

enter image description here

How can I modify the existing formula so that I do not have the 'sum' header and the blank line (if I can at all)? I want to avoid using multiple cells to create the desired affect and I want to avoid scripting.

Remove header and blank row from the results of a SUM, GROUP BY query

I have a two column table where one column is some sort of key where duplicates are allowed and the other column includes amounts.

I then have the following formula somewhere else on the sheet:

=QUERY(A1:B, "SELECT SUM(A) GROUP BY B")

The results of that query begin with 'sum', then a blank line, then the summed values:

spreadsheet with sum

How can I modify the existing formula so that I do not have the 'sum' header and the blank line (if I can at all)? I want to avoid using multiple cells to create the desired affect and I want to avoid scripting.

Source Link
Robert Hickman
Robert Hickman
  • 602
  • 1
  • 6
  • 11

How can I avoid the header and blank row from the results of this query?

I have a two column table where the one column is some sort of key where duplicates are allowed and the other column is some sort of amount. I then have the following formula somewhere else on the sheet:

=QUERY(A1:B, "SELECT SUM(A) GROUP BY B")

The results of that query begin with 'sum', then a blank line, then the summed values. See screenshot:

enter image description here

How can I modify the existing formula so that I do not have the 'sum' header and the blank line (if I can at all)? I want to avoid using multiple cells to create the desired affect and I want to avoid scripting.