3

I recently started to use QUERYs on Google Sheets. I just encountered a problem where after typing my query

=QUERY('Copy of TEST'!A1:E7,"select A, sum(D) 
group by A")

it is compounding the A1 row with the Title of my columns (in this case is "Service Type Updates"), and the row A2 that belongs to the first service ("Consultation").

Service Type Updates Consultations sum Tier 1 1

I have tried everything adding an extra row between those to rows but nothing.

Improve this question
1
  • 1
    try: =QUERY('Copy of TEST'!A1:E7,"select A, sum(D) group by A LABEL SUM(D)''")
    – Jacob Jan
    Commented Apr 27, 2021 at 7:59

1 Answer 1

Reset to default
1

You can try excluding the header row from the query, by starting the range with A2 instead of A1:

=QUERY('Copy of TEST'!A2:E7,"select A, sum(D) group by A")
Improve this answer
2
  • Thank you, I tried it but now because I'm using sum(D) is bringing this result in the totals =: sum Tier 1 1.
    – user267286
    Commented Mar 22, 2021 at 6:31
  • 1
    Can you share what data you have in the table?
    – Glorfindel
    Commented Mar 22, 2021 at 6:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.