How to write a google sheets query for summing by columns

Question

I've got a sheet where I'd like to sum each column B-D but filtered/grouped by the value in Column A.

If I use a basic query like

=QUERY(B1:N100, "select sum(B) where A = 'whatever'")

then I get a single value out- the values in B, summed.

How do I alter this query so that I get a single value out for each column, B-N?

Answer 1

try:

=QUERY(A1:N100, 
 "select sum(B),sum(C),sum(D),sum(E),sum(F),sum(G),sum(H),sum(I),sum(J),sum(K),sum(L),sum(M),sum(N) 
  where A = 'whatever'")

or:

=QUERY({A1:N100}, 
 "select "&JOIN(",", "sum(Col"&SEQUENCE(COLUMNS(B:N))&")")&" 
  where Col1 = 'whatever'")

or:

=BYCOL(FILTER(B1:N100, A1:A100="whatever"), LAMBDA(x, SUM(x)))