Google Sheets Query - Divide by Sum(Col), Error

Question

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.

Welcome to Web Applications Stack Exchange.
– doubleunary
Oct 6, 2021 at 9:52 — doubleunary, Oct 6, 2021 at 9:52

doubleunary · Accepted Answer · 2021-10-06 09:51:42Z

0

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

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

answered Oct 6, 2021 at 9:51

doubleunary

11.2k2 gold badges12 silver badges41 bronze badges

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
– decompluse
Oct 6, 2021 at 10:32
The policy here is just one question per post, so please post your new question in another topic.
– doubleunary
Oct 6, 2021 at 12:17

Add a comment |

1 Answer 1