I'm doing a simple query but keep getting the error "Add_col_to_group_by_or_agg:Col1".

The formula is

=QUERY({L42:N63}, "Select (Col1*Col3)/Sum(Col1)",0)

What I'm looking for is just as straightforward as the column of result, multiply, then divide by the sum. Thank you in advance.


1 Answer 1


This is perhaps easier to do without query(), like this:

=arrayformula(L42:L63 * N42:N63 / sum(L42:L63))

  • thanks for that @doubleunary, I actually forgot to mentioned that, the range "L42:N63" is going to be replaced by the result from another query. Something like =QUERY(QUERY({Range}), "Select (Col1*Col3)/Sum(Col1)",0). I was just putting the range in actual cell to test which part I'm getting wrong. So by that I think I've to do it using query. I think the problem came from the "/SUM(Col1)" part, after some testing. But I just not knowledgeable enough to understand what is going wrong here. Thanks
    – NG_
    Commented Oct 6, 2021 at 10:32
  • The policy here is just one question per post, so please post your new question in another topic. Commented Oct 6, 2021 at 12:17

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.