Search code examples
google-sheetsgoogle-sheets-formulagoogle-sheets-querygoogle-query-language

How can I avoid seeing "sum()" at the top of a query where I've summed two columns?

In the same row as this formula, I see sum() with the accurate results below. How can I remove this text from the results?

=QUERY(projectTasksAdj!A3:R51,"SELECT A,B,C,D,E,F,G+H",0)

shee

My sheet

Solution

  • You need to use the clause "label"

    Try this:

    =QUERY(projectTasksAdj!A3:T51,"SELECT A,B,C,D,E,F,G+H where I is not NULL label G+H ''",0)