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.